| From: | Sacheen Birhade <sacheen(dot)birhade(at)veritas(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | How to choose new master from slaves.? |
| Date: | 2022-08-04 07:43:28 |
| Message-ID: | MW4PR20MB45253764C649AF76E4B9B7E7F39F9@MW4PR20MB4525.namprd20.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Olarte | 2022-08-04 07:51:01 | Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? |
| Previous Message | Martin Kalcher | 2022-08-04 05:46:10 | Re: [PATCH] Introduce array_shuffle() and array_sample() |