pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Synchronize Postgres with an other database
2+ messages / 2 participants
[nested] [flat]

* Synchronize Postgres with an other database
@ 2005-09-26 15:55 hue <hue@lavoisier.fr>
  2005-09-27 17:45 ` Re: Synchronize Postgres with an other database David Stanaway <david@stanaway.net>
  0 siblings, 1 reply; 2+ messages in thread

From: hue @ 2005-09-26 15:55 UTC (permalink / raw)
  To: pgsql-interfaces

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.
 
 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Synchronize Postgres with an other database
  2005-09-26 15:55 Synchronize Postgres with an other database hue <hue@lavoisier.fr>
@ 2005-09-27 17:45 ` David Stanaway <david@stanaway.net>
  0 siblings, 0 replies; 2+ messages in thread

From: David Stanaway @ 2005-09-27 17:45 UTC (permalink / raw)
  To: hue <hue@lavoisier.fr>; +Cc: 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.
> 
>  
> 
>  
> 
> 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-09-27 17:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-26 15:55 Synchronize Postgres with an other database hue <hue@lavoisier.fr>
2005-09-27 17:45 ` David Stanaway <david@stanaway.net>

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