Re: Mirroring tables from Oracle to Postgresql

Andrew Rawnsley wrote:

> The java code is reasonably agnostic, provided the JDBC driver is smart
> enough to
> deal with any datatype properly as strings, although that intelligence
> can be added.
> Something else as a slave would be considerable easier, of course. For
> something
> else to be the master, you would have to find a way to mimic the
> trigger code to make
> the entry into the _rserve_log_?_ tables.

Not only that. I was wondering how exactly a "snapshot" would be defined
in Oracle. I don't know if there are things like minxid, maxxid and xip
in any other DB than PostgreSQL.


Jan

>
> On Apr 16, 2004, at 8:17 AM, Andrew Sullivan wrote:
>
>> On Mon, Apr 05, 2004 at 03:58:36PM +0200, Miguel Guzman Miranda wrote:
>>>     I've been suggested to do a triggered procedure in Oracle so that
>>> everytime a file is inserted, deleted or updated, a perl script is run
>>> which modifies in turn the PSQL DB.
>>
>> If you go to gborg and get the latest erserver code, you could
>> probably use that as a base.  It works pretty much as you described.
>> At the moment, it is designed to use Postgres as the master, but I've
>> been thinking about it lately, and it strikes me that it could be
>> modified to use other RDBMS.  Since the data is pushed around using
>> JDBC, I suspect that it could be modified to sync any systems for
>> which you have a JDBC driver.  Some work will be required for that,
>> though.  In particular, it depends on the Postgres system tables, so
>> you'd have to figure out how to fix that.
>>
>> Note that it does not do DDL, and it imposes a noticable cost to
>> transactions on the master database.
>>
>> A
>>
>> --
>> Andrew Sullivan  | ajs@crankycanuck.ca
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>>     (send "unregister YourEmailAddressHere" to
>> majordomo@postgresql.org)
>>
> --------------------
>
> Andrew Rawnsley
> President
> The Ravensfield Digital Resource Group, Ltd.
> (740) 587-0114
> www.ravensfield.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #