Re: Semi OT - Anyone monitoring PostgreSQL with nagios

["Anjan Dave" <adave@xxxxxxxxxxx>]

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@xxxxxxxxx]
Sent: Monday, November 07, 2005 4:19 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: 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

--- Begin Message ---

• To: "Juraj Holtak" <juraj@xxxxxxxxxx>, "Jon Jensen" <jon@xxxxxxxxxxxx>, "Anjan Dave" <adave@xxxxxxxxxxx>
• Subject: Re: [PERFORM] Monitoring Postgresql performance
• From: "Tony Wasson" <ajwasson@xxxxxxxxx>
• Date: Fri, 30 Sep 2005 15:57:16 -0500
• Cc: <pgsql-performance@xxxxxxxxxxxxxx>
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=sV5qMMZI0H3RfsV7/sq1YXZqW7yBLQ4JhAYynEpdNqUBXmNdyeCChspQGQokA9coSJVxwIQL7uG7GN+KjXQXrWPixyK90Vz8yJjtGd1/isdQMxvzK3Y4z2lO4n1zOb3X3fqkM4wKmd0ZhXdOx3qGugWgUzzCqawAPRg0jqh5uAk=
• In-reply-to: <1128027402.10516.25.camel@xxxxxxxxxxxxxxxxxxxxx>
• Reply-to: "Tony Wasson" <ajwasson@xxxxxxxxx>
• Thread-index: AcXGAYuuJyt54inFSs25fokLg6iWpQ==
• Thread-topic: [PERFORM] Monitoring Postgresql performance

Title: Re: [PERFORM] Monitoring Postgresql performance

On 9/29/05, Juraj Holtak <juraj@xxxxxxxxxx> 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

Attachment: pgnagios.zip
Description: pgnagios.zip

--- End Message ---

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match