Monitor postgreSQL databases with MCS in UIM

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

This technical document provides an overview of how to achieve monitoring of postgreSQL databases using MCS configuration in UIM.

Environment

Release : 20.4.x 
Component : UIM - MON_CONFIG_SERVICE_TEMPLATES

Cause

Guidance

Resolution

For monitoring PostgreSQL, we don't have a dedicated probe. PostgreSQL can be monitored using the jdbc_response and in combination with a dedicated PostgreSQL template to use with MCS. 

The PostgreSQL Profile is currently CR (Controlled Release) and will be made GA in a future release of the product. No ETA at this time. 

1. Download postgresql_mcs_templates.zip & jdbc_response-1.25.zip. (ATTACHED TO THIS KB) 
2. Import both packages into the local Primary Hub Archive. 
3. Deploy the "postgresql_mcs_templates.zip" package to the Primary Hub Robot (where mon_config_service probe is hosted). 
4. Access the Operator Console -> Select a Group -> Select the MCS button -> Add Profiles -> The "PostgreSQL" template version 2.9 should now be available. 
   
   

 

Notes:
- Both packages are attached to this article. Before importing to the local UIM Primary Hub Archive, the packages must be renamed to the expected format (example: postgresql_mcs_templates.zip & jdbc_response-1.25.zip). 
- Both postgresql_mcs_templates.zip & jdbc_response-1.25.zip are Controlled Release packages and are still in development / testing before being made GA. No ETA. 
- Packages also available for download via the Archive -> Controlled Release section of the Support.Nimsoft Site: http://support.nimsoft.com/Default.aspx?center=felles/archive&state=CR 

Any questions or concerns please contact Broadcom Technical Support. 

Additional Information

Related Knowledge Base Articles:

• jdbc_response probe in MCS - what are the queries used in the profiles to collect metrics for PostgreSQL databases? - https://knowledge.broadcom.com/external/article?articleId=14213
• Monitor PostgresSQL database using the UIM jdbc_response probe (broadcom.com) - https://knowledge.broadcom.com/external/article?articleId=35831
• jdbc_response - creating a connection to a PostgreSQL database- https://knowledge.broadcom.com/external/article?articleId=34407