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
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... ? |