synchronize two pg databases

postgresql replication
yjfuk picture yjfuk · Aug 18, 2009 · Viewed 24k times · Source

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 separate so that they don't clash with each other. eg: oddnumber pkey for laptop and even number for desktop.

Now how do I synchronize the data between the desktop and laptop cleanly?

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?

Answer

Tometzky picture Tometzky · Aug 18, 2009

It looks like rubyrep would work for you.

Related questions

How to delete replication slot in postgres 9.4

I have replication slot which I want to delete but when I do delete I got an error that I can't delete from view. Any ideas? postgres=# SELECT * FROM pg_replication_slots ; slot_name | plugin | slot_type | datoid | database | active | …

Read More
How to check the replication delay in PostgreSQL?

I would like to measure time between insert data into master-table and slave-table using streaming replication in PostgreSQL 9.3. For this I create table test_time with 2 fields id(serial), t(text). After that added a trigger: cur_time:=to_char(…

Read More
How do I fix a PostgreSQL 9.3 Slave that Cannot Keep Up with the Master?

We have a master-slave replication configuration as follows. On the master: postgresql.conf has replication configured as follows (commented line taken out for brevity): max_wal_senders = 1 wal_keep_segments = 8 On the slave: Same postgresql.conf as on the master. …

Read More