Sync three different postgres database on three different servers

Question

Is there any way to sync three different postgres database on three different servers which is located in three different location and each server is responsible for writing different types of data however each server should have another servers data?

For Example: Server : A, B, C Data : 1, 2, 3.

Each server should have three data 1, 2 and 3.

However only:

Server A that's allowed to update the data 1.
Server B that's allowed to update the data 2.
Server C that's allowed to update the data 3.

yet each server should have the updated on each data.

postgresql.org/docs/8.3/static/high-availability.html

JSON C11
– JSON C11

2017-10-03 04:29:06 +00:00
Commented Oct 3, 2017 at 4:29 — JSON C11
– JSON C11, Commented Oct 3, 2017 at 4:29

Cœur · Accepted Answer · 2018-11-13 11:37:40Z

2

PostgreSQL does not support sharding by default. However, there are some forks from Postgres sourcecode or some plugins, which support sharding to some extent(not sure that will suffice your requirement).

https://blog.dbi-services.com/sharding-with-postgresql/

Solution 1: My suggestion would be to manage sharding on application level, for e.g. store records starting with A-F on server 1, G- Z on server 2. But if you want to query all data together, this might not be good approach.

Solution 2: If you want to pull the data from diff servers or deal with it together. Then in that case, you should prefer replicating the data like Master-Master topology with Sticky sessions.

edited Nov 13, 2018 at 11:37

Cœur

39k25 gold badges207 silver badges282 bronze badges

answered Oct 3, 2017 at 6:07

Jaydeep Rajput

3,70320 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sync three different postgres database on three different servers

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related