pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Semi 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