[check_postgres] [commit] Version bump to 1.9.0
check_postgres at bucardo.org
check_postgres at bucardo.org
Sun Jun 22 20:53:29 UTC 2008
Committed by Greg Sabino Mullane <greg at endpoint.com>
Version bump to 1.9.0
---
.perlcriticrc | 2 +-
check_postgres.pl.asc | 6 ++--
check_postgres.pl.html | 50 +++++++++++++++++++++++++++++++++++++----------
index.html | 6 ++--
4 files changed, 46 insertions(+), 18 deletions(-)
diff --git a/.perlcriticrc b/.perlcriticrc
index 898a410..1aa2cb3 100644
--- a/.perlcriticrc
+++ b/.perlcriticrc
@@ -4,7 +4,7 @@ verbose = 8
severity = 1
[Documentation::PodSpelling]
-stop_words = Mullane Nagios Slony nols salesrep psql dbname postgres USERNAME usernames dbuser pgpass nagios stderr showperf symlinked timesync criticals quirm lancre exabytes sami includeuser excludeuser flagg tardis WAL tablespaces tablespace perflimit burrick mallory grimm oskar ExclusiveLock garrett artemus queryname speedtest checksum checksums morpork klatch pluto faceoff slon greg watson franklin wilkins scott Sabino Seklecki dbpass autovacuum Astill refactoring NAGIOS localhost cronjob symlink symlinks backends snazzo logfile syslog parens plugin Cwd Ioannis Tambouras
+stop_words = Mullane Nagios Slony nols salesrep psql dbname postgres USERNAME usernames dbuser pgpass nagios stderr showperf symlinked timesync criticals quirm lancre exabytes sami includeuser excludeuser flagg tardis WAL tablespaces tablespace perflimit burrick mallory grimm oskar ExclusiveLock garrett artemus queryname speedtest checksum checksums morpork klatch pluto faceoff slon greg watson franklin wilkins scott Sabino Seklecki dbpass autovacuum Astill refactoring NAGIOS localhost cronjob symlink symlinks backends snazzo logfile syslog parens plugin Cwd Ioannis Tambouras schemas
## Severity 5:
[-Subroutines::ProhibitNestedSubs]
diff --git a/check_postgres.pl.asc b/check_postgres.pl.asc
index b31344f..c79e2c1 100644
--- a/check_postgres.pl.asc
+++ b/check_postgres.pl.asc
@@ -1,6 +1,6 @@
-----BEGIN PGP SIGNATURE-----
-iEYEABEDAAYFAkhefMMACgkQvJuQZxSWSshPOgCfU3IZNpkor0lDMtbp/M8sdmuC
-wLsAoOFmy+NLRZ3LBDAPskvoLPM85KPe
-=5WgR
+iEYEABEDAAYFAkheu7UACgkQvJuQZxSWSsjD5gCdHUb6q0wamfg/Iby8vuj3JVMh
+pMIAn1o2jFX56lZDeSXYA2sARdXn//dH
+=wgCV
-----END PGP SIGNATURE-----
diff --git a/check_postgres.pl.html b/check_postgres.pl.html
index b14a918..e20d16f 100644
--- a/check_postgres.pl.html
+++ b/check_postgres.pl.html
@@ -51,7 +51,7 @@
</p>
<hr />
<h1><a name="version">VERSION</a></h1>
-<p>This documents describes <strong>check_postgres.pl</strong> version 1.8.5</p>
+<p>This documents describes <strong>check_postgres.pl</strong> version 1.9.0</p>
<p>
</p>
<hr />
@@ -361,6 +361,10 @@ values, you can look for the variables <strong>$MINPAGES</strong> and <strong>$M
<code>check_bloat</code> subroutine.</p>
</dd>
<dd>
+<p>The schema named 'information_schema' is excluded from this test, as the only tables
+it contains are small ans do not change.</p>
+</dd>
+<dd>
<p>Please note that the values computed by this action are not precise, and
should be used as a guideline only. Great effort was made to estimate the
correct size of a table, but in the end it is only an estimate. The correct
@@ -597,15 +601,19 @@ will be given. To prevent this, it is recommended that you set the
check_postgres_index_size --port=5432 --excludeuser=postgres -w 500MB -c 600MB</pre>
</dd>
</li>
+<dt><strong><a name="last_vacuum" class="item"><strong>last_vacuum</strong> (symlink: <code>check_postgres_last_vacuum</code>)</a></strong>
+
+<dt><strong><a name="last_autovacuum" class="item"><strong>last_autovacuum</strong> (symlink: <code>check_postgres_last_autovacuum</code>)</a></strong>
+
<dt><strong><a name="last_analyze" class="item"><strong>last_analyze</strong> (symlink: <code>check_postgres_last_analyze</code>)</a></strong>
-<dt><strong><a name="last_vacuum" class="item"><strong>last_vacuum</strong> (symlink: <code>check_postgres_last_vacuum</code>)</a></strong>
+<dt><strong><a name="last_autoanalyze" class="item"><strong>last_autoanalyze</strong> (symlink: <code>check_postgres_last_autoanalyze</code>)</a></strong>
<dd>
<p>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 Postgres
-configuration variable <strong>stats_rows_level</strong> is enabled, and that the target
-database is version 8.2 or higher. Tables can be filtered with the
+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 <strong>stats_rows_level</strong> is enabled. Tables can be filtered with the
<strong>--include</strong> and <strong>--exclude</strong> options. See the <a href="#basic_filtering">BASIC FILTERING</a> section
for more details.
Tables can also be filtered by their owner by use of the
@@ -622,6 +630,10 @@ are giving you problems, make sure that they have dead rows to vacuum,
or just exclude them from the test.</p>
</dd>
<dd>
+<p>The schema named 'information_schema' is excluded from this test, as the only tables
+it contains are small and do not change.</p>
+</dd>
+<dd>
<p>Example 1: Warn if any table has not been vacuumed in 3 days, and give a
critical at a week, for host wormwood</p>
</dd>
@@ -1037,18 +1049,20 @@ the format <strong>X.Y</strong> or <strong>X.Y.Z</strong> where <strong>X</stron
<p>The options <strong>--include</strong> and <strong>--exclude</strong> can be combined to limit which
things are checked, depending on the action. The name of the database can
be filtered when using the following actions:
-backends, database_size, last_vacuum, last_analyze, locks, and query_time.
+backends, database_size, locks, query_time, txn_idle, and txn_time.
The name of a relation can be filtered when using the following actions:
-bloat, index_size, table_size, and relation_size.
+bloat, index_size, table_size, relation_size, last_vacuum, last_autovacuum,
+last_analyze, and last_autoanalyze.
The name of a setting can be filtered when using the settings_checksum action.
-The name of a file system can be filtered when using the disk_space action.
-The name of a setting can be filtered when using the settings_checksum action.</p>
+The name of a file system can be filtered when using the disk_space action.</p>
<p>If only an include option is given, then ONLY those entries that match will be
checked. However, if given both exclude and include, the exclusion is done first,
and the inclusion after, to reinstate things that may have been excluded. Both
<strong>--include</strong> and <strong>--exclude</strong> can be given multiple times,
and/or as comma-separated lists. A leading tilde will match the following word
as a regular expression.</p>
+<p>To match a schema, end the search term with a single period. Leading tildes can
+be used for schemas as well.</p>
<p>Examples:</p>
<p>Only checks items named pg_class:</p>
<pre>
@@ -1065,6 +1079,9 @@ as a regular expression.</p>
<p>Exclude all items containing the letters 'test:</p>
<pre>
--exclude=~test</pre>
+<p>Exclude all items in the schema 'pg_catalog':</p>
+<pre>
+ --exclude='pg_catalog.'</pre>
<p>Exclude all items containing the letters 'ace', but allow the item 'faceoff':</p>
<pre>
--exclude=~ace --include=faceoff</pre>
@@ -1086,8 +1103,12 @@ comma-separated list. The actions that currently use these options are:</p>
<dt><strong>last_analyze</strong>
+<dt><strong>last_autoanalyze</strong>
+
<dt><strong>last_vacuum</strong>
+<dt><strong>last_autovacuum</strong>
+
<dt><strong>query_time</strong>
<dt><strong>relation_size</strong>
@@ -1116,7 +1137,7 @@ comma-separated list. The actions that currently use these options are:</p>
specifying the <strong>--test</strong> option. This will perform some basic tests to
make sure that the databases can be contacted, and that certain per-action
prerequisites are met, such as whether the user is a superuser, if the version
-of Postgres is new enough, and if stats_row_level is on.</p>
+of Postgres is new enough, and if stats_row_level is enabled.</p>
<p>
</p>
<hr />
@@ -1170,6 +1191,13 @@ feature requests, and commit notices, send email to <a href="mailto:check_postgr
<h1><a name="history">HISTORY</a></h1>
<p>Items not specifically attributed are by Greg Sabino Mullane.</p>
<dl>
+<dt><strong><a name="0" class="item"><strong>Version 1.9.0</strong> (June 22, 2008)</a></strong>
+
+<dd>
+<p>Don't include information_schema in certain checks. (Jeff Frost)
+Allow --include and --exclude to use schemas by using a trailing period.</p>
+</dd>
+</li>
<dt><strong><a name="5" class="item"><strong>Version 1.8.5</strong> (June 22, 2008)</a></strong>
<dd>
@@ -1205,7 +1233,7 @@ Allow for different commands to be run for each action depending on the server v
Give better warnings when running actions not available on older Postgres servers.</p>
</dd>
</li>
-<dt><strong><a name="0" class="item"><strong>Version 1.8.0</strong> (June 3, 2008)</a></strong>
+<dt><strong><strong>Version 1.8.0</strong> (June 3, 2008)</strong>
<dd>
<p>Add the --reverse option to the custom_query action.</p>
diff --git a/index.html b/index.html
index a40a754..db487fb 100644
--- a/index.html
+++ b/index.html
@@ -21,13 +21,13 @@ h1 {
<h1>check_postgres.pl</h1>
-<p><b>check_postgres.pl</b> is a script for checking the state of one or more Postgres databases and reporting back in a Nagios-friendly manner. It was developed by Greg Sabino Mullane of <a href="http://www.endpoint.com/">End Point Corporation</a> and is BSD-licensed. The latest version is <b>1.8.5</b>, and was released on June 22, 2008.</p>
+<p><b>check_postgres.pl</b> is a script for checking the state of one or more Postgres databases and reporting back in a Nagios-friendly manner. It was developed by Greg Sabino Mullane of <a href="http://www.endpoint.com/">End Point Corporation</a> and is BSD-licensed. The latest version is <b>1.9.0</b>, and was released on June 22, 2008.</p>
<ul>
- <li><a href="/check_postgres/check_postgres.pl.html">Documentation for check_postgres 1.8.5</a></li>
+ <li><a href="/check_postgres/check_postgres.pl.html">Documentation for check_postgres 1.9.0</a></li>
</ul>
<ul>
- <li><a href="/check_postgres/check_postgres.pl">Download check_postgres.pl 1.8.5</a></li>
+ <li><a href="/check_postgres/check_postgres.pl">Download check_postgres.pl 1.9.0</a></li>
<li><a href="/check_postgres/check_postgres.pl.asc">PGP signature for check_postgres.pl</a></li>
</ul>
--
1.5.5.4
More information about the Check_postgres
mailing list