I'm not familiar with Nagios, but you should be able to do something like psql -tc 'select 1' database to see if it's alive and accepting queries. On Mon, Nov 07, 2005 at 04:18:55PM -0500, Chris Hoover wrote: > 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 -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
