Обсуждение: Oracle to PostgreSQL replication
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?
I was wondering has anyone used foreign data wrapper or
Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
Вложения
Sameer Kumar wrote: > 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? > > I was wondering has anyone used foreign data wrapper or There is no ready-made solution for this from the PostgreSQL side. You could check with Oracle if they provide something like that with their "Golden Gate". What you could do is to have a trigger record all changes to the Oracle table in a separate log table and regularly run a program that pulls those changes from the log table and applies them to a PostgreSQL table, deleting the log entries as it goes. You could write such a thing as PostgreSQL function using oracle_fdw, but you need PostgreSQL 9.3 if you want to update Oracle data that way. Yours, Laurenz Albe
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 RACMy Postgres database version is 9.2Oracle 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
Hi,
How about EnterpriseDB XDB replication?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?
Kind regards/met vriendelijke groet,
2014-05-07 11:44 GMT+02:00 Geoff Montee <geoff.montee@gmail.com>:
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 RACMy Postgres database version is 9.2Oracle 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
Thanks alot everyone!
I guess I will be exploring more on oracle foreign data wrapper.
Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would it handle failovers.
You can test with SymmetricDS (www.symmetricds.org)
![](https://mail.google.com/mail/u/0/images/cleardot.gif)
On Thu, May 8, 2014 at 10:35 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
You can test with SymmetricDS (www.symmetricds.org)On Thu, May 8, 2014 at 12:53 PM, Sameer Kumar <sameer.kumar@ashnik.com> wrote:Thanks alot everyone!I guess I will be exploring more on oracle foreign data wrapper.Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would it handle failovers.
We use symmetricDS for this. Works pretty well.
From: Serge Fonville <serge.fonville@gmail.com>
Date: Wednesday, May 7, 2014 at 2:49 AM
To: Geoff Montee <geoff.montee@gmail.com>
Cc: Sameer Kumar <sameer.kumar@ashnik.com>, PostgreSQL General Discussion Forum <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Oracle to PostgreSQL replication
Date: Wednesday, May 7, 2014 at 2:49 AM
To: Geoff Montee <geoff.montee@gmail.com>
Cc: Sameer Kumar <sameer.kumar@ashnik.com>, PostgreSQL General Discussion Forum <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Oracle to PostgreSQL replication
Hi,
How about EnterpriseDB XDB replication?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?
Kind regards/met vriendelijke groet,
2014-05-07 11:44 GMT+02:00 Geoff Montee <geoff.montee@gmail.com>:
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 RACMy Postgres database version is 9.2Oracle 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
I downloaded symmetricDS but I did not found any installer (symmetric-pro-x.x.x.jar)
Can any one please help me in this
Thanks
Best Regards,
Rajni Baliyan | Database - Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M:+65 87294147 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
On Fri, May 9, 2014 at 4:11 AM, Anand Kumar, Karthik <Karthik.AnandKumar@classmates.com> wrote:
We use symmetricDS for this. Works pretty well.From: Serge Fonville <serge.fonville@gmail.com>
Date: Wednesday, May 7, 2014 at 2:49 AM
To: Geoff Montee <geoff.montee@gmail.com>
Cc: Sameer Kumar <sameer.kumar@ashnik.com>, PostgreSQL General Discussion Forum <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Oracle to PostgreSQL replicationHi,How about EnterpriseDB XDB replication?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?
Kind regards/met vriendelijke groet,2014-05-07 11:44 GMT+02:00 Geoff Montee <geoff.montee@gmail.com>: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 RACMy Postgres database version is 9.2Oracle 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
Вложения
Rajni Baliyan, 09.05.2014 09:46: > I downloaded symmetricDS but I did not found any installer (symmetric-pro-x.x.x.jar) > Can any one please help me in this This might help: http://www.symmetricds.org/doc/3.5/html/tutorial.html#tutorial-install
Sameer Kumar wrote: > I guess I will be exploring more on oracle foreign data wrapper. > > Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would it handle failovers. I have not tried it, but it should work as follows: - You'll have to use a connect string that is correctly defined for "transparent application failover", see http://docs.oracle.com/cd/E11882_01/network.112/e10836/advcfg.htm#NETAG455 - Failover will happen automatically. - SELECTs should be able to complete without error message. - INSERT, UPDATE and DELETE will fail with an error message and will have to be retried. I did not code oracle_fdw to support TAF for DML statements. Yours, Laurenz Albe