| From: | David Stanaway <david(at)stanaway(dot)net> |
|---|---|
| To: | hue <hue(at)lavoisier(dot)fr> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Synchronize Postgres with an other database |
| Date: | 2005-09-27 17:45:38 |
| Message-ID: | 1127843138.23735.4.camel@dmxnocws13.dialmex.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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.
>
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zlatko Matić | 2005-10-02 23:14:57 | Unbound text box, Text > 255 characters, MSAccess/PostgreSQL |
| Previous Message | hue | 2005-09-26 15:55:34 | Synchronize Postgres with an other database |