Обсуждение: Semi OT - Anyone monitoring PostgreSQL with nagios

Поиск
Список
Период
Сортировка

Semi OT - Anyone monitoring PostgreSQL with nagios

От
Chris Hoover
Дата:
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

Re: Semi OT - Anyone monitoring PostgreSQL with nagios

От
"Jim C. Nasby"
Дата:
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

Re: Semi OT - Anyone monitoring PostgreSQL with nagios

От
"Lane Van Ingen"
Дата:
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



Re: Semi OT - Anyone monitoring PostgreSQL with nagios

От
"Jim C. Nasby"
Дата:
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

Re: Semi OT - Anyone monitoring PostgreSQL with nagios

От
Eric Faulhaber
Дата:
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


Re: Semi OT - Anyone monitoring PostgreSQL with nagios

От
Steve Crawford
Дата:
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

Re: Semi OT - Anyone monitoring PostgreSQL with nagios

От
"Anjan Dave"
Дата:

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

Вложения