On 8/4/22 02:43, Sacheen Birhade wrote:
Hi All,
I have a very basic question about streaming replication feature of Postgres.
Let’s assume I have servers A, B, C, D, & E with postgres installed with
streaming replication as follow:
A à B ( sync replication )
A à C ( async replication )
A à D ( async replication )
A à E ( async replication )
A is master & rest are slaves.
Now my question is:
Assume replication link between A & B may/may not stable. If A goes down,
how will I choose my new master from slaves? What are criteria to choose
new master?
By "link between A & B may/may not stable", do you mean that B might not
actually be synchronized?
--
Angular momentum makes the world go 'round.