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
