Skip site navigation (1) Skip section navigation (2)

Re: Synchronize Postgres with an other database

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 (view raw or flat)
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.
> 
>  
> 
>  
> 
> 


In response to

pgsql-interfaces by date

Next:From: Zlatko MatićDate: 2005-10-02 23:14:57
Subject: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Previous:From: hueDate: 2005-09-26 15:55:34
Subject: Synchronize Postgres with an other database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group