Be Notify Upon Streaming Replication Failover

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Be Notify Upon Streaming Replication Failover
Date: 2021-06-15 06:13:51
Message-ID: DB9PR07MB71807CC04949A63DF7FCD304CB309@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-06-15 07:01:12 Re: Kill postgresql process
Previous Message Vineet Naik 2021-06-15 06:10:48 Re: Autovacuum or manual vacuum to recover from XID wraparound?