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