[Nagiosplug-devel] [ nagiosplug-Feature Requests-1516150 ] check_pgsql.c check plugin for Postgres DB

[SourceForge.net]

Feature Requests item #1516150, was opened at 2006-07-03 08:57
Message generated for change (Comment added) made by jsianes
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397600&aid=1516150&group_id=29880

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Submitted By: Jose Javier Sianes Ruiz (jsianes)
Assigned to: Nobody/Anonymous (nobody)
Summary: check_pgsql.c check plugin for Postgres DB

Initial Comment:
Here is a PostgreSQL check program for Nagios that
connect to a Postgres DB and check the current version.
Similar to check_mysql.c submited by me few days ago,
this is adapted for PGSQL API and works correctly for
postgres 7 and 8.


----------------------------------------------------------------------

>Comment By: Jose Javier Sianes Ruiz (jsianes)
Date: 2006-07-03 09:03

Message:
Logged In: YES 
user_id=1241156

Example configuration:

In 'checkcommands.cfg' add:

# 'check_pgsql' command definition
define command{
        command_name    check_pgsql
        command_line    $USER1$/contrib/check_pgsql
$HOSTADDRESS$ $ARG1$ $ARG2$ $ARG3$ $ARG4$
        }

And in 'services.cfg' add at least one check for Postgres
service:

define service{
       use                             generic-service     
   ; Name of service template to use

       host_name                       MyServer
       service_description             POSTGRESQL
       is_volatile                     0
       check_period                    24x7
       max_check_attempts              3
       normal_check_interval           3
       retry_check_interval            1
       contact_groups                  administrators
       notification_interval           120
       notification_period             24x7
       notification_options            w,u,c,r
       check_command                  
check_pgsql!username!password!database!5432
       }


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397600&aid=1516150&group_id=29880