synchronize two pg databases

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

Browse pgsql-general by date

  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