Recently while importing a new physical schema from PostgreSQL 8.4 into Oracle Data Integrator(ODI) via JDBC driver all of the tables were reversing into the model without data types defined for text, double precision, smallint, integer and boolean. If one or two fields are missing it’s easy enough to set the data type manually for [...]
Posts Tagged ‘PostgreSQL’
Reverse PostgreSQL into model with undefined data types
Posted in Oracle Data Integrator, tagged data types, ODI, PostgreSQL, reverse on June 30, 2011 | Leave a Comment »
Automatic cron backup of PostgreSQL database
Posted in Bash, Postgres, tagged backup, cron, pgsql, pg_dump, PostgreSQL, shell script on June 3, 2011 | Leave a Comment »
There are lots of great backup tools and utilities out there, but utilizing a simple script and cron task to target specific PostgreSQL database is often the fastest way to a locally based backup procedure. The below shell script is run as the postgres user on a Linux version 2.6.9-42.0.3.ELsmp (Red Hat 3.4.6-3) with PostgreSQL [...]
