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 correct

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 (pg

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-09 Thread Rajni Baliyan
mates.com> wrote: > We use symmetricDS for this. Works pretty well. > > http://www.symmetricds.org/ > > > From: Serge Fonville > Date: Wednesday, May 7, 2014 at 2:49 AM > To: Geoff Montee > Cc: Sameer Kumar , PostgreSQL General Discussion > Forum > Subject: R

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-08 Thread Anand Kumar, Karthik
PostgreSQL General Discussion Forum 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 ver

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 wrote: > You can test with SymmetricDS (www.*symmetricds*.org) > > > On Thu, May 8, 2014 at 12:53 PM, Sameer Kumar wrote: > >> >> Thanks alot everyone! >> >> I guess I will be exploring more on o

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.

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 Post

Re: [GENERAL] Oracle to PostgreSQL replication

2014-05-07 Thread Geoff Montee
On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar 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 ve

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 ru

[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 i

[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 q