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@xxxxxx | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature
