From: | sreekant kodela <sreekant_kodela(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to synchronize two pg databases |
Date: | 2003-12-13 10:48:22 |
Message-ID: | 20031213104822.29420.qmail@web20813.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi guys
I have a postgresql server process each running in my
desktop and the laptop.
Both servers have a database called MG with exactly
same scheme/layout. Now I enter the data in to similar
tables but at differing times.
I generally keep the primary keys seperate so that
they don't clash with each other. eg: oddnumber pkey
for laptop and even number for desktop.
Now how do I syncronize the data between the desktop
and laptop cleanly!
Any advise would be greatly appreciated.
DESK:ADDRESS ----- LAP:ADDRESS
DESK:TO_DO ----- LAP:TO_DO
DESK uses pkeys like 1001... for inserts
LAP uses pkeys like 2001... for inserts
I need both update for the modified records and insert
for new records. But how do I :-( ..
etc...
Thanks
A novice
sreekant
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Biagioni | 2003-12-13 15:18:18 | Mis-interpreted extended character |
Previous Message | Sai Hertz And Control Systems | 2003-12-13 10:33:37 | Re: [PERFORM] Tables Without OIDS and its effect |