Re: replication from Oracle to PostgreSQL?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: replication from Oracle to PostgreSQL?
Date: 2011-08-11 19:58:17
Message-ID: 4E443459.1080401@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lonni J Friedman 2011-08-11 20:03:14 streaming replication questions
Previous Message CS DBA 2011-08-11 18:24:27 PostgreSQL fails to bind IPv6 socket at startup on AIX platform