[check_postgres] Any chance the schema name can be output with the
last analyze and last vacuum warnings?
Jeff Frost
jeff at frostconsultingllc.com
Sat Jun 21 03:43:50 UTC 2008
It seems they are in the performance data, but not in the actual message
that nagios emails you. Here's a git diff of the change that seems to
do the trick:
diff --git a/check_postgres.pl b/check_postgres.pl
index 5d2ee3c..119ca44 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -1907,7 +1907,7 @@ sub check_last_vacuum_analyze {
$db->{perf} .= " $schema.$name=$time" if $time >= 0;
if ($time > $maxtime) {
$maxtime = $time;
- $maxrel = $name;
+ $maxrel = "$schema.$name";
$maxptime = $ptime;
}
}
I attached it as a text file as well in case thunderbird does something
bad with the formatting.
--
Jeff Frost, Owner <jeff at frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
-------------- next part --------------
diff --git a/check_postgres.pl b/check_postgres.pl
index 5d2ee3c..119ca44 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -1907,7 +1907,7 @@ sub check_last_vacuum_analyze {
$db->{perf} .= " $schema.$name=$time" if $time >= 0;
if ($time > $maxtime) {
$maxtime = $time;
- $maxrel = $name;
+ $maxrel = "$schema.$name";
$maxptime = $ptime;
}
}
More information about the Check_postgres
mailing list