PostgreSQL - Migrating from Oracle to Postgres Using ora2pg

# tar xzf ora2pg-7.x.tar.gz
# cd ora2pg-7.x/
# perl Makefile.PL
# make && make install

# perl -MCPAN -e 'install DBI'

# export ORACLE_HOME
# export LD_LIBRARY_PATH=$ORACLE_HOME/lib
# perl -MCPAN -e 'install DBD::Oracle'

Edit /etc/ora2pg/ora2pg.conf to modify ORACLE_HOST ORACLE_USER ORACLE_PASSWORD