Re: pg_standby: How to check in which state the server is currently?

Am 05.12.2011 17:02, schrieb Cédric Villemain:
> Le 5 décembre 2011 12:16, Frank Lanitz <frank(at)frank(dot)uvena(dot)de> 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