Am 05.12.2011 17:02, schrieb Cédric Villemain: > Le 5 décembre 2011 12:16, Frank Lanitz <frank@xxxxxxxxxxxxxx> a écrit : >> Hi list, >> >> We had in past from time to time the issue, that the standby server is >> stopping recovering, creating a new timeline and become up and running. >> In parallel to check for the reasons of this behavior we are looking for >> a clean way to check whether warm standby database is still in >> recovering mode or has become ready. I did some search, but didn't found >> any ready-2-use script for doing this on a stand alone basis (should >> only be temp. solution that will be replaced by real monitoring later) > > See check_postgres , I have added that recently for similar purpose. > You give it one of '--assume-standby-mode' or '--assume-prod' when > you check the last checkpoint. > If the server is not in the expected mode, emit CRITICAL (for nagios, > but check_postgres is a standlone script and can be used with other > supervision/monitoring software) > It is not yet release, see : > https://github.com/bucardo/check_postgres/commit/0ff408711dab18b05de26656a945fa37e363f6aa > (depends on other patches but you get the idea) > http://bucardo.org/wiki/Check_postgres A first view looks very promissing. Will have a deeper look ;) Cheers, Frank -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
