Answer the question
In order to leave comments, you need to log in
Is it possible to set up 1 slave for multiple masters in Postgresql?
Colleagues, good time of day.
there is a task - a certain (significant) number of PostgreSQL master nodes at remote points, it is necessary to raise a similar number of slaves in the data center to them. It is clear that raising a lot of individual Postgres servers is not very efficient. Those. there is a desire to raise 1 (2-3) server in the data center and replicate data there. Found that multi-slave configurations are possible.
But the question is - what will happen when the remote master stops working? I will need to be on this server in the data center at the same time a slave for a bunch of servers - and a master for 1 (2-3, etc.). Those. 1 physical server must be both master and slaves at the same time. Partitioning at the Postgres DB/Cluster level?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question