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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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