Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to PostgreSQL replication - Mailing list pgsql-general

From Geoff Montee
Subject Re: Oracle to PostgreSQL replication
Date
Msg-id CAA7biFPc1S3Bz9++k53SJAUkchwaWKVZw3MqRXKEYnfU=QdG0g@mail.gmail.com
Whole thread Raw
In response to Oracle to PostgreSQL replication  (Sameer Kumar <sameer.kumar@ashnik.com>)
Responses Re: Oracle to PostgreSQL replication
List pgsql-general
Tree view

On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar <sameer.kumar@ashnik.com> 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.



Geoff Montee

pgsql-general by date:

Previous
From: Rémi Cura
Date:
Subject: Re: Re: any psql \copy tricks for default-value columns without source data?
Next
From: Serge Fonville
Date:
Subject: Re: Oracle to PostgreSQL replication