Re: replication from Oracle to PostgreSQL? - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: replication from Oracle to PostgreSQL?
Date
Msg-id 4E443459.1080401@commandprompt.com
Whole thread Raw
In response to Re: replication from Oracle to PostgreSQL?  (CS DBA <cs_dba@consistentstate.com>)
Responses Re: replication from Oracle to PostgreSQL?
List pgsql-admin
On 08/11/2011 07:57 AM, CS DBA wrote:
>
>> On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>>> Anyone know of tools / options that will allow Oracle to PostgreSQL
>>> replication? or at least a real time feed or dblink?
>> EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
>> solution bundled.
>>
>> Regards,
>
> That was the first thing I tried to push 'em towards... they shut it
> down cause it's not free (which is weird since they're not considering a
> real TCO, but they are the customer).

I would aimagine it would be pretty simple to fork the triggers that do
replication in Londiste or Slony (as long as everything else was
PostgreSQL) to be able to replicate from Oracle to PostgreSQL.

JD


>
>
>
>


--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579

pgsql-admin by date:

Previous
From: CS DBA
Date:
Subject: PostgreSQL fails to bind IPv6 socket at startup on AIX platform
Next
From: Lonni J Friedman
Date:
Subject: streaming replication questions