synchronize two pg databases

Question

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 :-( ..

Answer 1

It looks like rubyrep would work for you.

Answer 2

The simplest way would be to write a custom script/program. It's not difficult, and definitely you will know and understand how it works, so extending it will be trivial.

Answer 3

Please refer to PostgreSQL documentation for High Availability, Load Balancing, and Replication

Answer 4

Use Slony-I to do postgreSQL synchronization.