From aa7a0f44995eac442872420c4248ab7621d1df18 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 2 Feb 2011 17:35:13 -0500 Subject: Bump version and redo html docs. --- check_postgres.pl.html | 43 ++++++++++++++++++++++++++++++++++--------- 1 file changed, 34 insertions(+), 9 deletions(-) (limited to 'check_postgres.pl.html') diff --git a/check_postgres.pl.html b/check_postgres.pl.html index 6769fac4f..367c94261 100644 --- a/check_postgres.pl.html +++ b/check_postgres.pl.html @@ -117,7 +117,7 @@
check_postgres.pl - a Postgres monitoring script for Nagios, MRTG, Cacti, and others
-This documents describes check_postgres.pl version 2.17.0
+This documents describes check_postgres.pl version 2.17.1
(symlink: check_postgres_txn_idle
) Checks the length of "idle in transaction" queries on one or more databases. There is
-no need to run this more than once on the same database cluster. Databases can be filtered
-by using the --include and --exclude options. See the BASIC FILTERING
+
(symlink: check_postgres_txn_idle
) Checks the number and duration of "idle
+in transaction" queries on one or more databases. There is no need to run this
+more than once on the same database cluster. Databases can be filtered by
+using the --include and --exclude options. See the BASIC FILTERING
section below for more details.
The --warning and --critical options are given as units of time, and both must -be provided (there are no defaults). Valid units are 'seconds', 'minutes', 'hours', -or 'days'. Each may be written singular or abbreviated to just the first letter. -If no units are given, the units are assumed to be seconds.
+The --warning and --critical options are given as units of time, signed +integers, or integers for units of time, and both must be provided (there are +no defaults). Valid units are 'seconds', 'minutes', 'hours', or 'days'. Each +may be written singular or abbreviated to just the first letter. If no units +are given and the numbers are unsigned, the units are assumed to be seconds.
This action requires Postgres 8.0 or better. Additionally, if the version is less than 8.3, the 'stats_command_string' parameter must be set to 'on'.
Example 1: Give a warning if any connection has been idle in transaction for more than 15 seconds:
check_postgres_txn_idle --port=5432 --warning='15 seconds'+
Example 2: Give a warning if there are 50 or more transactions
++ check_postgres_txn_idle --port=5432 --warning='+50'+
Example 4: Give a critical if 5 or more connections have been idle in +transaction for more than 10 seconds:
++ check_postgres_txn_idle --port=5432 --critical='5 for 10 seconds'
For MRTG output, returns the time in seconds the longest idle transaction has been running. The fourth line returns the name of the database.
@@ -1595,6 +1604,22 @@ feature requests, and commit notices, send email to HISTORY
Items not specifically attributed are by Greg Sabino Mullane.
+ Set maxliagn to 8 in the bloat check if box identified as '64-bit' + (Michel Sijmons, bug #66)+
+ Support non-standard version strings in the bloat check. + (Michel Sijmons and Gurjeet Singh, bug #66)+
+ Allow "and", "or" inside arguments (David E. Wheeler)+