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

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.

 

Thanks!

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
On 2021-06-13 08:00:24 +0000, Avi Weinberg 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.

I just do
    patronictl list -f yaml | grep -v 'Lag in MB'
periodically and send an email if the output changes. Of course instead
of sending an email the script could take any other action.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment