Обсуждение: finding best possible new master in case of failover?

Поиск
Список
Период
Сортировка

finding best possible new master in case of failover?

От
Sacheen Birhade
Дата:

Hi Laurenz & all,

 

In a multitarget replication (a master with multiple slaves) with asynchronous replication mode,

How can We find best possible new master in case of failover?

 

Thank in advance.

 

Thanks,

Sacheen Birhade.

Re: finding best possible new master in case of failover?

От
Laurenz Albe
Дата:
On Tue, 2022-11-01 at 07:00 +0000, Sacheen Birhade wrote:
> In a multitarget replication (a master with multiple slaves) withasynchronous replication mode, 
> How can We find best possible new master in case of failover?

Pick the one with the latest pg_last_wal_receive_lsn().

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com