Oracle to PostgreSQL replication - Mailing list pgsql-general

From Sameer Kumar
Subject Oracle to PostgreSQL replication
Date
Msg-id CADp-Sm75yopXE0p3F+dTdhYX724_FujJ8kTLt0NPLe8LcoStEQ@mail.gmail.com
Whole thread Raw
Responses Re: Oracle to PostgreSQL replication  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Oracle to PostgreSQL replication  (Geoff Montee <geoff.montee@gmail.com>)
List pgsql-general
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

icons

 

Email patch

 

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

Attachment

pgsql-general by date:

Previous
From: Tim Kane
Date:
Subject: Re: DDL statement blocked on long-running query with no runtime dependancy
Next
From: "Huang, Suya"
Date:
Subject: ERROR: permission denied for database control