Re: Semi OT - Anyone monitoring PostgreSQL with nagios

Tony Wasson not too long ago was kind enough to forward some of his
scripts for nagios monitoring of pg. They are attached.

-anjan

_____

From: Chris Hoover [mailto:revoohc(at)gmail(dot)com]
Sent: Monday, November 07, 2005 4:19 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Semi OT - Anyone monitoring PostgreSQL with nagios

Is anyone using Nagios to monitor PostgreSQL?

If so, is there any way to check for more than just your PostgreSQL
instance being up?

This weekend, we had an issue where a database shutdown failed due to a
rogue query that would not die w/o a kill -9 being done on it. The
database remained up and accepted connections only to tell the
connection to go away because the database was shutting down.

This up and accepting connections caused our Nagios instance to not
report the database being down.

Any ideas on how to get around this?

Thanks,

Chris