From: Avi Weinberg <AviW@gilat.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Be Notify Upon Streaming Replication Failover
Date: Tue, 15 Jun 2021 06:13:51 +0000
Message-ID: <DB9PR07MB71807CC04949A63DF7FCD304CB309@DB9PR07MB7180.eurprd07.prod.outlook.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: AviW@gilat.com, pgsql-admin@lists.postgresql.org
Subject: Re: Be Notify Upon Streaming Replication Failover
In-Reply-To: <DB9PR07MB71807CC04949A63DF7FCD304CB309@DB9PR07MB7180.eurprd07.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox