| 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: | Whole Thread | Raw Message | 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... ? |