From: | Andrew Rawnsley <ronz(at)ravensfield(dot)com> |
---|---|
To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Mirroring tables from Oracle to Postgresql |
Date: | 2004-04-16 15:41:34 |
Message-ID: | 8A20B329-8FBC-11D8-919A-000393A47FCC@ravensfield.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
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(at)crankycanuck(dot)ca
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>
--------------------
Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com
From | Date | Subject | |
---|---|---|---|
Next Message | Uwe C. Schroeder | 2004-04-16 15:44:22 | Re: A simple question about Read committed isolation level |
Previous Message | scott.marlowe | 2004-04-16 15:33:43 | Re: [HACKERS] Remove MySQL Tools from Source? |