Postgres Pro
Downloads
Home   >   mailing lists

How to choose new master from slaves. - Mailing list pgsql-novice

From Sacheen Birhade
Subject How to choose new master from slaves.
Date
Msg-id MW4PR20MB4525A0AEC2F749ED7ACA9710F39F9@MW4PR20MB4525.namprd20.prod.outlook.com
Whole thread Raw
List pgsql-novice
Tree view

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?

 

Thanks,

Sacheen Birhade

pgsql-novice by date:

Previous
From: BeeRich Lists
Date:
Subject: log_directory & Permissions
Next
From: Sacheen Birhade
Date:
Subject: switch between async to sync automatically