So, if something happens to the standby, and it cannot return an ack in
30 seconds, they would like it to degrade to asynch mode. At that
point, they would also like to trigger a nagios alert which will wake up
the sysadmin with flashing red lights.
How?
TBD, and before 9.1. It's clear to *me* that we're going to need some
read-only system views around replication in order to make monitoring
work. Also, given that we have this shiny new LISTEN/NOTIFY
implementation, it would be peachy keen to maybe make use of it to emit
an event when replication changes, no?
Otherwise, DBAs are forced to tail the logs to figure out what
replication status is. This is NOT adequate.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
