How to monitor postgres database
search cancel

How to monitor postgres database


Article ID: 189131


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)


I need to monitor PostgreSQL database servers.

Is there a dedicated PostgresSQL probe or another option?


  • Release: 9.x
  • PostgreSQL version 9.0 or greater 
  • jdbc_response probe
  • sql_response probe


- guidance


Currently, there is no dedicated out of the box probe to monitor the PostgreSQL database server.
That stated, by following the steps below you can enable monitoring of this SQL database by utilizing the jdbc_response probe.
For CA Unified Infrastructure Management version 8.5.1 or greater, use jdbc_response probe version 1.25 or greater.
The jdbc_response probe is required for communication with the PostgreSQL instance. Find attached
Note that for postgreSQL, there is one profile which combines setup and monitoring. PostgreSQL monitoring is implemented as an MCS Profile Type only. There is no Admin Console configuration.
Use the PostgreSQL profile type to monitor checkpoints for a database instance, and generate alarms and QoS metrics for the selected checkpoints.
  • All configuration settings are in a single profile type.
  • The alarms and QoS metrics settings appear in table format.
  • The checkpoints the postgreSQL profile is capable of monitoring appear in the leftmost column.
Provide the following information to connect the postgreSQL profile to the PostgreSQL database:
Database Name
Host Name where the PostgreSQL database is hosted

For additional configuration and details visit our techdocsat:

postgreSQL (PostgreSQL Monitoring) 

postgreSQL MCS Profile Type Configuration

Additional Information

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 (Be sure to have the Postgres database driver installed)

Attachments get_app