Monitoring postgresql warm standby

[ufocek]

Hi,

Someone have any ideas how can monitoring postgresql whic is running in recovery mode (warm standby)?

./pg_controldata ../data/
pg_control version number:            843
Catalog version number:               200908111
Database system identifier:           5562407258672709630
Database cluster state:               [B]in archive recovery [/B]
pg_control last modified:             Thu 03 Mar 2011 02:39:58 PM CET
Latest checkpoint location:           42/42E6827C

Only way is write some script?

[JBo]

Hi,

Only way is write some script?

Short answer, yes.

If you are only interested in 'Database cluster state' value, it can be a one liner in zabbix_agentd.conf
Something like:

UserParameter=pg.cluster_state, pg_controldata data | sed -n 's/Database cluster state: *//p'

See UserParameter doc. for details

Regards,
JBo