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

Keeping 2 db updated each-other

From: Sandro Dentella <sandro(dot)dentella(at)mi(dot)infn(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Keeping 2 db updated each-other
Date: 2000-02-28 19:21:57
Message-ID: 200002281921.UAA09349@bluff.ermit.it (view raw or flat)
Thread:
Lists: 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(dot)dentella(at)mi(dot)infn(dot)it sandro(at)ermit(dot)it

pgsql-general by date

Next:From: Peter EisentrautDate: 2000-02-28 23:19:44
Subject: Re: [GENERAL] psql 7.0.0 beta
Previous:From: Henrique PantarottoDate: 2000-02-28 18:20:06
Subject: RE: RES: [GENERAL] Stored procedures returning multiple values... ?

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