psql -c COMMAND DATABASE
executes COMMAND using DATABASE and displays the results without
starting psql interactively.
Regards,
Eric Faulhaber
Lane Van Ingen wrote:
What does the 'c' part of the -tc command do? It is not documented in
any information I have.
-----Original Message-----
From: pgsql-admin-owner@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx]On Behalf Of Jim C. Nasby
Sent: Monday, November 07, 2005 5:38 PM
To: Chris Hoover
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Semi OT - Anyone monitoring PostgreSQL with nagios
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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
