[check_postgres] Any chance the schema name can be output with the last analyze and last vacuum warnings?

[Jeff Frost]

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;
 			}
 		}