X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 27E3DD7C9D for ; Tue, 8 Nov 2005 15:35:10 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93557-07 for ; Tue, 8 Nov 2005 19:35:07 +0000 (GMT) X-Greylist: delayed 03:06:38.741986 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 1D751D7B14 for ; Tue, 8 Nov 2005 15:35:07 -0400 (AST) Received: from www.goldencode.com (smtp.goldencode.com [72.17.138.114]) by svr2.postgresql.org (Postfix) with ESMTP id 7ED2AF1020 for ; Tue, 8 Nov 2005 16:28:27 +0000 (GMT) Received: from emlsrv01.internal.goldencode.com (emlsrv01.internal.goldencode.com [192.168.1.51]) by www.goldencode.com (Postfix) with SMTP id 9A2A3636 for ; Tue, 8 Nov 2005 11:29:21 -0500 (EST) Received: from goldencode.com (ecf.internal.goldencode.com [192.168.1.103]) by emlsrv01.internal.goldencode.com (Hethmon Brothers Smtpd) id 20051108121945-11147-7 ; Tue, 08 Nov 2005 12:19:45 -0500 Message-ID: <4370D22A.4090802@goldencode.com> Date: Tue, 08 Nov 2005 11:28:26 -0500 From: Eric Faulhaber Organization: Golden Code Development User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040114 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Lane Van Ingen Cc: pgsql-admin@postgresql.org Subject: Re: Semi OT - Anyone monitoring PostgreSQL with nagios References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/80 X-Sequence-Number: 19453 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@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Jim C. Nasby > Sent: Monday, November 07, 2005 5:38 PM > To: Chris Hoover > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] 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@pervasive.com > 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