ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How do I enable monitoring of the PostgresSQL database using the UIM jdbc_response probe?


Article ID: 35831


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) NIMSOFT PROBES



As of UIM 8.31 there currently is not a dedicated probe to monitor the PostgreSQL database Server. By following the steps below you can enable monitoring of this SQL database by utilizing the jdbc_response probe.


  •  UIM 8.2 or UIM 8.31
  •  Controller version 7.X
  •  Jdbc_response probe 1.23
  •  UIM java_jre 1.7X


Part I - On PostgreSQL Server:

Depending on OS (Windows/Linux) and *NIX flavor (RPM-based or Debian-based), configuration may vary (please refer to your platform's PostgreSQL documentation). Generally PostgreSQL configuration file is postgresql.conf
  1. Enable Remote access for PostgreSQL:
        a. In postgresql.conf, make PostgreSQL Listen on Ethernet IP address: listen_addresses = ''
        b. Enable remote access from jdbc_response probe robot:
              In pg_hba.conf
              host all all password
        c. Restart PostgreSQL database service:
              # /etc/init.d/postgresql restart
    2. Create/allow PostgreSQL monitoring user:
        a. Login to PostgreSQL using 'psql' command as an admin user
              $psql -U pguser -W
              Enter password for the PostgreSQL admin user
        b. Create PostgreSQL monitoring user:
              postgres =# createuser dbuser with password 'password';
        c. Grant new user access to monitored databse:
               postgres=# grant all on database pgdb to dbuser;


Part-II - On 'jdbc_response' Probe Robot:

  1. Download PostgreSQL JDBC Driver from PostgreSQL site:
  2. Rename postgresql-8.4-701.jdbc4.jar to pg.jar for your convenience to use driver name
  3. Copy pg.jar to \probe\database\jdbc_response\jar\
  4. Change runprobe.bat:
      set CLASSPATH should look like this:
      set CLASSPATH=jar\jdbc_response.jar;jar\nimsoft.jar;jar\TwoFish.jar;jar\oracle.jar;jar\sql_drv.jar;jar\pg.jar
     Verify the existence of jar\pg.jar
  5. In jdbc_response probe connection properties:
      Database URL: jdbc:postgresql://
      Driver Name: org.postgresql.Driver
      Driver Path: /Program Files/Nimsoft/probes/database/jdbc_response/jar/pg.jar
      User ID: dbuser
      Password: dbuser_password
You should be able to connect PostgreSQL Server database using the jdbc_response probe.


  1. Make sure you have JRE installed on jdbc_response probe robot.
  2. On PostgreSQL server, modify firewall rules to allow connection to PostgreSQL port (default is 5432/tcp).
  3. URL to jdbc driver could be outdated but should be able to find the latest from the website. 


Additional Alternative:

You can use the sql_response probe to monitor a Postgresql database.
You can add Postgresql as successfully queried through an ODBC connection using the Postgresql ODBC driver.

The PostgreSQL database driver can be downloaded from the following location:



Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem