From: Joshua D. Drake <jd@commandprompt.com>
To: pgsql-admin@postgresql.org
Subject: Re: replication from Oracle to PostgreSQL?
Date: Thu, 11 Aug 2011 12:58:17 -0700
Message-ID: <4E443459.1080401@commandprompt.com> (raw)
In-Reply-To: <4E43EDD4.1060700@consistentstate.com>
References: <4E43EA0B.3080600@consistentstate.com>
<1313074397.2506.710.camel@lenovo01-laptop03.gunduz.org>
<4E43EDD4.1060700@consistentstate.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com
Subject: Re: replication from Oracle to PostgreSQL?
In-Reply-To: <4E443459.1080401@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox