[check_postgres] [commit] Be clear about our GREATEST hack.

check_postgres at bucardo.org check_postgres at bucardo.org
Wed Feb 4 16:46:36 UTC 2009


Committed by Greg Sabino Mullane <greg at endpoint.com>

Be clear about our GREATEST hack.

---
 check_postgres.pl |    6 +++++-
 1 files changed, 5 insertions(+), 1 deletions(-)

diff --git a/check_postgres.pl b/check_postgres.pl
index ec60ecc..404e693 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -4532,7 +4532,7 @@ C<check_postgres_last_autoanalyze>)
 Checks how long it has been since vacuum (or analyze) was last run on each 
 table in one or more databases. Use of these actions requires that the target 
 database is version 8.3 or greater, or that the version is 8.2 and the 
-configuration variable B<stats_row_level> is enabled. Tables can be filtered with the 
+configuration variable B<stats_row_level> has been enabled. Tables can be filtered with the 
 I<--include> and I<--exclude> options. See the L</"BASIC FILTERING"> section 
 for more details.
 Tables can also be filtered by their owner by use of the 
@@ -4550,6 +4550,10 @@ or just exclude them from the test.
 The schema named 'information_schema' is excluded from this test, as the only tables 
 it contains are small and do not change.
 
+Note that the non-'auto' versions will also check on the auto versions as well. In other words, 
+using last_vacuum will report on the last vacuum, whether it was a normal vacuum, or 
+one run by the autovacuum daemon.
+
 Example 1: Warn if any table has not been vacuumed in 3 days, and give a 
 critical at a week, for host wormwood
 
-- 
1.6.0.5



More information about the Check_postgres mailing list