Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-09 Thread Rajni Baliyan
-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

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-09 Thread Thomas Kellerer
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

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-09 Thread Albe Laurenz
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

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-08 Thread tuanhoanganh
You can test with SymmetricDS (www.*symmetricds*.org) On Thu, May 8, 2014 at 10:35 PM, tuanhoanganh hatua...@gmail.com wrote: You can test with SymmetricDS (www.*symmetricds*.org) On Thu, May 8, 2014 at 12:53 PM, Sameer Kumar sameer.ku...@ashnik.comwrote: Thanks alot everyone! I guess

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-08 Thread Anand Kumar, Karthik
...@ashnik.commailto:sameer.ku...@ashnik.com, PostgreSQL General Discussion Forum pgsql-general@postgresql.orgmailto:pgsql-general@postgresql.org Subject: Re: [GENERAL] Oracle to PostgreSQL replication Hi, I need to setup a replication process for continuously replicating changes happening

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-07 Thread Albe Laurenz
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

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-07 Thread Geoff Montee
On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar sameer.ku...@ashnik.comwrote: 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

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-07 Thread Serge Fonville
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

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-07 Thread Sameer Kumar
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.

[GENERAL] Oracle to PostgreSQL replication

2014-05-06 Thread Sameer Kumar
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

[GENERAL] Oracle to PostgreSQL replication with Goldengate

2012-11-11 Thread Jayadevan M
Hello all, GoldenGate added PostgreSQL as a target database for replication. I tried setting it up, and not finding any tutorial, put together a how to here - http://jayadevanm.wordpress.com/2012/11/07/goldengate-replication-from-oracle-to-postgresql/ I think near real-time replication might have