How to monitor postgres database

Products

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

Issue/Introduction

I need to monitor PostgreSQL database servers.

Is there a dedicated PostgresSQL probe or another option?

Environment

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

Cause

- guidance

Resolution

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 postgresql_mcs_templates.zip.

 

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

 

PostgreSQL 

Port

 

PostgreSQL 

User

 

PostgreSQL 

Password

For additional configuration and details visit our techdocsat:

postgreSQL (PostgreSQL Monitoring)
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/postgresql-postgresql-monitoring.html 

postgreSQL MCS Profile Type Configuration
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/monitoring/bigdata-databases-and-storage/postgresql-postgresql-monitoring/postgresql-mcs-profile-type-configuration.html

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)

Documentation for the sql_response probe can be found here:  sql_response (SQL Response Monitoring)

https://knowledge.broadcom.com/external/article?articleId=35831

https://knowledge.broadcom.com/external/article?articleId=14213