Do you mean PostgreSQL 8 or any 8.X version?

EnterpriseDB's products are based on Postgres 8.X. For example, Postgres Plus Standard Server core is the same as PostgreSQL 8.4. The Standard Server bundle includes other open source projects that most people end up using, i.e. replication, connectors, pgAdmin, etc.

So, if you were to move from PostgreSQL to Postgres Plus Standard Server, the move is simply to use pg_dump...

I know it has been awhile since this was posted but it might help others having the same problem...

You need to check that the postgresql.conf file parameter, listen_addresse s, is set to accept remote connections. It defaults to localhost so change it to '*' so it can listen to for any IP connection or specify a specific IP address.

If you are not looking to migrate the database, EnterpriseDB also has a replication tool that replicates data from Oracle to Postgres Plus Advanced Server(based on PostgreSQL).

That is a trigger based replication solution. If that doesn't work for you, then you might want to take a look at database links in Postgres Plus Advanced Server. They allow you to create a link between Postgres Plus Advanced Server to Oracle. Then you can...

You have a couple of options.

If you port straight to Postgres, then you need a tool that can create the tables, indexes, constraints and move the data from Oracle to Postgres. There are tools out there such as EnterpriseDB's migration tool in Postgres Plus Standard Server. It will migrate all the table definitions, indexes, constraints and data for you.

Postgres Plus Standard Server migration toolkit documentation:...