From 6c416a229706948db4c4fac9175e4b92ba76b092 Mon Sep 17 00:00:00 2001
From: Greg Sabino Mullane
Date: Thu, 27 Aug 2009 13:05:46 -0400
Subject: Update docs.
---
check_postgres.pl.html | 23 +++++++++++++++++++----
1 file changed, 19 insertions(+), 4 deletions(-)
(limited to 'check_postgres.pl.html')
diff --git a/check_postgres.pl.html b/check_postgres.pl.html
index d30194ed7..ba54b1804 100644
--- a/check_postgres.pl.html
+++ b/check_postgres.pl.html
@@ -1017,6 +1017,8 @@ provide a --verbose
argument, which will output one item per line.<
to the --warning
option. To exclude a type of object, use "noobjectnames". To exclude
objects of a certain type by a regular expression against their name, use "noobjectname=regex".
See the examples for a better understanding.
You may exclude all objects of a certain name by using the exclude
option. It takes a Perl
+regular expression as its argument.
The types of objects that can be filtered are:
Example 1: Verify that two databases on hosts star and line are the same:
- check_postgres_same_schema --dbhost=star --dbhost=line+ check_postgres_same_schema --dbhost=star --dbhost2=line
Example 2: Same as before, but exclude any triggers with "slony" in their name
- check_postgres_same_schema --dbhost=star --dbhost=line --warning="notrigger=slony"-
Example 2: Same as before, but also exclude all indexes
+ check_postgres_same_schema --dbhost=star --dbhost2=line --warning="notrigger=slony" +Example 3: Same as before, but also exclude all indexes
- check_postgres_same_schema --dbhost=star --dbhost=line --warning="notrigger=slony noindexes"+ check_postgres_same_schema --dbhost=star --dbhost2=line --warning="notrigger=slony noindexes" +
Example 3: Don't show anything starting with "pg_catalog"
++ check_postgres_same_schema --dbhost=star --dbhost2=line --exclude="^pg_catalog"
Items not specifically attributed are by Greg Sabino Mullane.
+ Proper Nagios output for last_vacuum|analyze actions. (Cédric Villemain) + Proper Nagios output for locks action. (Cédric Villemain) + Proper Nagios output for txn_wraparound action. (Cédric Villemain) + Fix for constraints with embedded newlines for same_schema. + Allow --exclude for all items when using same_schema.+