jdbc_response - creating a connection to a PostgreSQL database

Document ID : KB000034407
Last Modified Date : 17/10/2018
Show Technical Document Details

 This article provides instructions on how to create a connection to a PostgreSQL database using the jdbc_response probe.




    Depending on OS(Windows/Linux) and *NIX flavor (RPM-based or Debian-based), configuration may vary (please refer to your platform's PostgreSQL documentation).
    jdbc_response probe any version.
    Part I - On PostgreSQL database server:

    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:

    a. Download PostgreSQL JDBC Driver from PostgreSQL site:

    b. Rename postgresql-8.4-701.jdbc4.jar to pg.jar for your convenience to use driver name

    c. Copy pg.jar to \probe\database\jdbc_response\jar\

    d. 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

    Note jar\pg.jar

    e. 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 now be able to connect PostgreSQL Server database using the jdbc_response probe.
    Additional Information:
    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.
    File Attachments: