postgresql 🔗 link

Hi !

Got anybody an addon for monitoring
for a postgresql-db ?

I've find only theses two threads

http://lists.xymon.com/oldarchive/2008/04/msg00163.html

.. the server is not reachable anymore :-(

http://lists.xymon.com/oldarchive/2008/04/msg00163.html

.. not very helpful for me :-(

thanks & cheers

        Martin

I haven't had the time to look at this yet (but I need to for work...it's on my todo list).  If you are using a RHEL variant (not sure if it's available as a package for other OSes) there is a check_postgres monitoring script available.  Pretty sure it interfaces readily with Nagios and a couple of other so it may not be too hard to convert it to work for Xymon.

=G=

From: Xymon [xymon-bounces at xymon.com] on behalf of user-f286aaa49a76@xymon.invalid [user-f286aaa49a76@xymon.invalid]
Sent: Tuesday, July 30, 2013 8:54 AM
To: xymon at xymon.com
Subject: [Xymon] postgresql

Hi !

Got anybody an addon for monitoring
for a postgresql-db ?

I've find only theses two threads

http://lists.xymon.com/oldarchive/2008/04/msg00163.html

.. the server is not reachable anymore :-(

http://lists.xymon.com/oldarchive/2008/04/msg00163.html

.. not very helpful for me :-(

thanks & cheers

        Martin

Thanks, i will test
when i come back from holiday :-)


cheers,
 	martin

On Tue, 30 Jul 2013, Galen Johnson wrote:

Gruss

        Martin Flemming


Martin Flemming
DESY / IT          office : Building 2b / 008a
Notkestr. 85       phone  : XXX - XXXX - XXXX
22603 Hamburg      mail   : user-f286aaa49a76@xymon.invalid

Hi,

in debian distributions, there is a package named hobbit-plugins. This
package contain a general class hobbit.pm and besides others, it
contains a script names postgres that monitor various parameters of
postgresql. Tha package itself is maintained by Axel Beckert.

These are the plugins included:
 * apt - check for outstanding updates
 * dirtyetc - check for conffiles which are modified compared to
 * dirtyvcs - check for not checked in modifications or files in VCS
 * ipmi - read IPMI sensors and event log
 * misc - plugin which can aggregate the output and states of other plugins
 * libs - check for running processes with upgraded libraries
 * mailman - check for the existence of Mailman qfiles.
 * mdstat - check for failed or resyncing software RAID devices
 * mq - checks (Postfix's) mail queue
 * ntpq - check the ntpd daemon synchronization status (needs ntp)
 * postgres - statistics graphs for postgresql databases
 * sftbnc - check if the local Postfix MTA has soft_bounce enabled.
 * aptdiff - monitor list of installed packages in host pools
 * conn6 - check IPv6 connectivity
 * ircbot - relay status changes to IRC
 * tftp - check downloading files from TFTP servers

I hope this helps.

CU,
Martin