Keeping 2 db updated each-other - Mailing list pgsql-general

Hi,

  I need to keep updated to databases (little ~ 100.000 record splitted in 15
  tables). Is there any general tip?

  Since the database is handles via tcl-tk I'm logging all
  update/delete/insert so as to pass the whole bunch of 'not yet updated'
  statement to the database that needs updating. This requires having all
  statements referenced w/ primary key becouse OID are different on different
  hosts. This seems to work but is quite tricky.

  Is there a better solution?

  Thanks in advance
  sandro



--
Sandro Dentella  *:-)
e-mail: sandro.dentella@mi.infn.it sandro@ermit.it