Oracle to PostgreSQL replication

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

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

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

Geoff Montee

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?

How about EnterpriseDB XDB
replication<http://www.enterprisedb.com/products-services-training/products/complementary-enterprisedb-products/xdb-replication-server&gt;
?

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

2014-05-07 11:44 GMT+02:00 Geoff Montee <geoff.montee@gmail.com>:

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)

On Thu, May 8, 2014 at 10:35 PM, tuanhoanganh <hatuan05@gmail.com> wrote:

We use symmetricDS for this. Works pretty well.

http://www.symmetricds.org/

From: Serge Fonville <serge.fonville@gmail.com<mailto:serge.fonville@gmail.com>>
Date: Wednesday, May 7, 2014 at 2:49 AM
To: Geoff Montee <geoff.montee@gmail.com<mailto:geoff.montee@gmail.com>>
Cc: Sameer Kumar <sameer.kumar@ashnik.com<mailto:sameer.kumar@ashnik.com>>, PostgreSQL General Discussion Forum <pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>>
Subject: Re: [GENERAL] 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?

How about EnterpriseDB XDB replication<http://www.enterprisedb.com/products-services-training/products/complementary-enterprisedb-products/xdb-replication-server&gt;?

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

2014-05-07 11:44 GMT+02:00 Geoff Montee <geoff.montee@gmail.com<mailto:geoff.montee@gmail.com>>:

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

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

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

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

*[image: icons]*

[image: Email patch] <http://www.ashnik.com/&gt;
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:

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general