Re: Oracle to PostgreSQL replication

[Geoff Montee <geoff.montee@xxxxxxxxx>]

On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar <sameer.kumar@xxxxxxxxxx> wrote:

Hi,

I need to setup a replication process for continuously replicating changes happening in an Oracle Database to a PostgreSQL database.

My Oracle Database is version 11.2 and setup as a cluster with RAC

My Postgres database version is 9.2

Oracle Database is running in Solaris and PostgreSQL is running on RHEL.

Is there any commercial or open source tool available to achieve this? 

Continuent's Tungsten Replicator apparently offers Oracle to MySQL replication. There's a wiki page that suggests PostgreSQL support was in development at one time. I'm not sure how far they got, or if they are still working on it.

http://www.continuent.com/solutions/replication

https://wiki.postgresql.org/wiki/Tungsten

Geoff Montee