Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

synchronize two pg databases

Tags:

postgresql

replication

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?

like image 290
yjfuk Avatar asked Aug 18 '09 06:08

yjfuk

People also ask

Is Postgres replication synchronous?

Synchronous Replication. PostgreSQL streaming replication is asynchronous by default. If the primary server crashes then some transactions that were committed may not have been replicated to the standby server, causing data loss. The amount of data loss is proportional to the replication delay at the time of failover.

How do I replicate a Postgres database?

For replication to be achieved in PostgreSQL there must be two servers that can communicate with each other. It will identify this server as master, which is the master server or the production server and the other one is the Slave server or Replica server or standby server that will have a copy of master server data.

1 Answers

It looks like rubyrep would work for you.

like image 140
Tometzky Avatar answered Nov 15 '22 10:11

Tometzky
Sign in to Comment

Related questions

approximate search in a database
Build complex rails SQL
Postgresql - Query running a lot faster with enable_nestloop=false. Why is the planner not doing the right thing?
Choosing the right partitioning rule
Postgres UTC date format & epoch cast, sign inversion
Converting Postgresql data to Open Street Maps
node.js + postgres database transaction management
Can't insert a record because of "malformed record literal"
pg_dump version mismatch in Rails
'service postgresql start' fails to start postgres service on Fedora
How to make a foreign key with a constraint on the referenced table in PostgreSQL
how do I set table ownership in rails with postgresql?
How to avoid race conditions when using the find_or_create method of DBIx::Class::ResultSet?
Add new column without table lock?
How to use pgFouine with PostgreSQL 9.1?
ERROR: subquery in FROM cannot refer to other relations of same query level
cursort.execute/cursor.callproc returns no error but nothing is executed
GROUP BY in Postgres - no equality for JSON data type?
Postgresql object ID and tuples
PostgreSQL: View database connect permissions

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!