From: David Stanaway <david@stanaway.net>
To: hue <hue@lavoisier.fr>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Synchronize Postgres with an other database
Date: Tue, 27 Sep 2005 12:45:38 -0500
Message-ID: <1127843138.23735.4.camel@dmxnocws13.dialmex.net> (raw)
In-Reply-To: <001401c5c2b2$be48daa0$51c809c0@HUEROBERT>
References: <001401c5c2b2$be48daa0$51c809c0@HUEROBERT>
How many changes per minute are you planning for? Looking to the WAL
files seems very low level, and I don't imagine it would be a good idea
unless performance dictated it.
Have you thought of setting up a trigger to log inserts/updates/deletes
into a transaction table/tables that you can poll with a java
application or whatever other language you want?
On Mon, 2005-09-26 at 17:55 +0200, hue wrote:
> Hi,
>
>
>
> I would like to read Postgres transaction log files to update an other
> database with an old structure base on files.
>
>
>
> The only solution I found is to read WAL files, but, the only way is
> with c program, I did not find a way to use WAL files with java
> program.
>
>
>
> Regards, Olivier.
>
>
>
>
>
>
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-interfaces@postgresql.org
Cc: david@stanaway.net, hue@lavoisier.fr
Subject: Re: Synchronize Postgres with an other database
In-Reply-To: <1127843138.23735.4.camel@dmxnocws13.dialmex.net>
* 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