Re: Notify When Streaming Replication Failover Occurred (slave promoted to master).

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Notify When Streaming Replication Failover Occurred (slave promoted to master).
Дата
Msg-id CADK3HHKVjhHbw-EBYG6nAQzDqMwb0etKRXPCFmbuiiVqFDD83A@mail.gmail.com
обсуждение исходный текст
Ответ на Notify When Streaming Replication Failover Occurred (slave promoted to master).  ("Avi Weinberg" <AviW@gilat.com>)
Ответы Re: Notify When Streaming Replication Failover Occurred (slave promoted to master).  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Список pgsql-general
Дерево обсуждения

On Sun, 13 Jun 2021 at 19:32, Avi Weinberg <AviW@gilat.com> wrote:

I need to take actions when Postgres streaming replication failover occurred.  Is there a way to be notified when Postgres slave becomes master?  If no such notification possible, what is the best way to actively monitor which server is master.  My Postgres  is running inside Kubernetes and the HA is managed by Patroni.

 


On the surface this seems like a great idea, however contemplating this a bit more; where would the signal come from ? Currently the only option I can think of is to send a NOTIFY. 
It seems to me that the Patroni code is a better place to do this from.

Dave

В списке pgsql-general по дате отправления:

Предыдущее
От: "Avi Weinberg"
Дата:
Сообщение: Notify When Streaming Replication Failover Occurred (slave promoted to master).
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: immutable function querying table for partitioning