pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSemi OT - Anyone monitoring PostgreSQL with nagios
7+ messages / 6 participants
[nested] [flat]
* Semi OT - Anyone monitoring PostgreSQL with nagios
@ 2005-11-07 21:18 Chris Hoover <revoohc@gmail.com>
2005-11-07 22:38 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 7+ messages in thread
From: Chris Hoover @ 2005-11-07 21:18 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Semi OT - Anyone monitoring PostgreSQL with nagios
2005-11-07 21:18 Semi OT - Anyone monitoring PostgreSQL with nagios Chris Hoover <revoohc@gmail.com>
@ 2005-11-07 22:38 ` Jim C. Nasby <jnasby@pervasive.com>
2005-11-08 13:10 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Lane Van Ingen <lvaningen@esncc.com>
0 siblings, 1 reply; 7+ messages in thread
From: Jim C. Nasby @ 2005-11-07 22:38 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Semi OT - Anyone monitoring PostgreSQL with nagios
2005-11-07 21:18 Semi OT - Anyone monitoring PostgreSQL with nagios Chris Hoover <revoohc@gmail.com>
2005-11-07 22:38 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Jim C. Nasby <jnasby@pervasive.com>
@ 2005-11-08 13:10 ` Lane Van Ingen <lvaningen@esncc.com>
2005-11-08 16:28 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Eric Faulhaber <ecf@goldencode.com>
2005-11-08 17:58 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Steve Crawford <scrawford@pinpointresearch.com>
2005-11-08 18:56 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 3 replies; 7+ messages in thread
From: Lane Van Ingen @ 2005-11-08 13:10 UTC (permalink / raw)
To: Jim C. Nasby <jnasby@pervasive.com>; Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Semi OT - Anyone monitoring PostgreSQL with nagios
2005-11-07 21:18 Semi OT - Anyone monitoring PostgreSQL with nagios Chris Hoover <revoohc@gmail.com>
2005-11-07 22:38 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Jim C. Nasby <jnasby@pervasive.com>
2005-11-08 13:10 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Lane Van Ingen <lvaningen@esncc.com>
@ 2005-11-08 16:28 ` Eric Faulhaber <ecf@goldencode.com>
2 siblings, 0 replies; 7+ messages in thread
From: Eric Faulhaber @ 2005-11-08 16:28 UTC (permalink / raw)
To: Lane Van Ingen <lvaningen@esncc.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Semi OT - Anyone monitoring PostgreSQL with nagios
2005-11-07 21:18 Semi OT - Anyone monitoring PostgreSQL with nagios Chris Hoover <revoohc@gmail.com>
2005-11-07 22:38 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Jim C. Nasby <jnasby@pervasive.com>
2005-11-08 13:10 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Lane Van Ingen <lvaningen@esncc.com>
@ 2005-11-08 17:58 ` Steve Crawford <scrawford@pinpointresearch.com>
2 siblings, 0 replies; 7+ messages in thread
From: Steve Crawford @ 2005-11-08 17:58 UTC (permalink / raw)
To: pgsql-admin
On Tuesday 08 November 2005 05:10, Lane Van Ingen wrote:
> What does the 'c' part of the -tc command do? It is not documented
> in any information I have.
Show tuples only (per psql --help)
Cheers,
Steve
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Semi OT - Anyone monitoring PostgreSQL with nagios
2005-11-07 21:18 Semi OT - Anyone monitoring PostgreSQL with nagios Chris Hoover <revoohc@gmail.com>
2005-11-07 22:38 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Jim C. Nasby <jnasby@pervasive.com>
2005-11-08 13:10 ` Re: Semi OT - Anyone monitoring PostgreSQL with nagios Lane Van Ingen <lvaningen@esncc.com>
@ 2005-11-08 18:56 ` Jim C. Nasby <jnasby@pervasive.com>
2 siblings, 0 replies; 7+ messages in thread
From: Jim C. Nasby @ 2005-11-08 18:56 UTC (permalink / raw)
To: Lane Van Ingen <lvaningen@esncc.com>; +Cc: Chris Hoover <revoohc@gmail.com>; pgsql-admin
Same as -t -c...
On Tue, Nov 08, 2005 at 08:10:28AM -0500, 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
>
--
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Semi OT - Anyone monitoring PostgreSQL with nagios
@ 2005-11-07 21:59 Anjan Dave <adave@vantage.com>
0 siblings, 0 replies; 7+ messages in thread
From: Anjan Dave @ 2005-11-07 21:59 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; pgsql-admin
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@gmail.com]
Sent: Monday, November 07, 2005 4:19 PM
To: pgsql-admin@postgresql.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
On 9/29/05, Juraj Holtak <juraj@proaut.org> wrote:
> Hi,
>
> impressive
>
> But you forgot to include those scipts as attachment or they got lost
> somehow ;-)
>
> could you post them (again)?
>
> thanx,
> Juraj
Attached you'll find the scripts I use in nagios to monitor
postgresql. I cleaned these up a bit but they are still rough. Please
let me know if you find these useful. I will see about getting these
are part of the nagios plugins package.
Tony Wasson
Attachments:
pgnagios.zip (application/zip, 7.7K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-11-08 18:56 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-07 21:18 Semi OT - Anyone monitoring PostgreSQL with nagios Chris Hoover <revoohc@gmail.com>
2005-11-07 22:38 ` Jim C. Nasby <jnasby@pervasive.com>
2005-11-08 13:10 ` Lane Van Ingen <lvaningen@esncc.com>
2005-11-08 16:28 ` Eric Faulhaber <ecf@goldencode.com>
2005-11-08 17:58 ` Steve Crawford <scrawford@pinpointresearch.com>
2005-11-08 18:56 ` Jim C. Nasby <jnasby@pervasive.com>
2005-11-07 21:59 Re: Semi OT - Anyone monitoring PostgreSQL with nagios Anjan Dave <adave@vantage.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox