Message-ID: <4E443459.1080401@commandprompt.com>
Date: Thu, 11 Aug 2011 12:58:17 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:5.0) Gecko/20110627 Thunderbird/5.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: replication from Oracle to PostgreSQL?
References: <4E43EA0B.3080600@consistentstate.com>
	<1313074397.2506.710.camel@lenovo01-laptop03.gunduz.org>
	<4E43EDD4.1060700@consistentstate.com>
In-Reply-To: <4E43EDD4.1060700@consistentstate.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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