[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