From: | leopay <leopay(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | synchronize two pg databases |
Date: | 2009-08-17 09:26:41 |
Message-ID: | e9369e430908170226j5bc10855t4308bac4789a31a6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the same problem with this guy.
http://archives.postgresql.org/pgsql-admin/2003-12/msg00205.php
>>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
From | Date | Subject | |
---|---|---|---|
Next Message | David De Maeyer | 2009-08-17 09:35:41 | binary timestamp conversion |
Previous Message | Scott Marlowe | 2009-08-17 09:19:02 | Re: Requesting help on PostgreSQL Replication |