[check_postgres] POSTGRES_LAST_VACUUM WARNING does not go away after a vacuum

George Hansper georgeh at infoxchange.net.au
Thu Jan 2 23:49:05 UTC 2014


Hi All,

I have a server which is running Postgres 8.3 on Debian 7.2

# /usr/bin/sudo -u postgres /usr/lib/nagios/plugins/check_postgres.pl --action last_vacuum --warning 35d --critical 70d
POSTGRES_LAST_VACUUM WARNING: DB "postgres" DB: postgres TABLE: pg_catalog.pg_ts_config: 20:58 November 27, 2013 (5 weeks 1 day 13 hours 15 minutes) | time=0.11s postgres.pg_catalog.pg_ts_config=3158128s;3024000;6048000 postgres.pg_catalog.pg_ts_dict=3158127s;3024000;6048000 ...

Running the vacuum manually as follows does not clear this warning:
sudo -u postgres /usr/bin/vacuumdb --all --analyze

Running a 'full' vacuum does (not) clear the problem either
sudo -u postgres /usr/bin/vacuumdb --full --analyze -all

# /usr/bin/sudo -u postgres /usr/lib/nagios/plugins/check_postgres.pl --action last_vacuum --warning 35d --critical 70d
POSTGRES_LAST_VACUUM WARNING: DB "postgres" DB: postgres TABLE: pg_catalog.pg_ts_config: 20:58 November 27, 2013 (5 weeks 1 day 13 hours 42 minutes) | time=0.13s

Has anyone else seen this problem?
Any ideas on how to clear this alert?
--

George Hansper | Senior Linux Systems Administrator

Infoxchange Australia  |  | www.infoxchange.net.au<http://www.infoxchange.net.au/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140102/9d561342/attachment.html>


More information about the Check_postgres mailing list