Troubleshooting Postgres SQL MP

  • Document ID:KM03637096
  • Creation Date:30-Apr-2020
  • Modified Date:30-Apr-2020
    • Micro Focus Products:
      operations bridge manager 2018.05

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

What data should be collected in Postgres SQL MP cases?

Question

What data should be collected in Postgres SQL MP cases?

Answer

 Discovery data:
# monitorframeworkperl monitorframework.pl  -debug -topology PostgreSQL_Collector.pm  

 Metric collection:
# monitorframeworkperl monitorframework.pl -production -developer PostgreSQL_Collector.pm 

 Log directories:
%ovdatadir%\log\monitors

 Operations Agent data:
# ovpolicy -list
# ovcodautil -showds
# ovcodautil -dumpds POSTGRESQL

 Postgres MP configuration file:
%ovdatadir%\conf\ManagementPack\Content\PostgreSQL_Collector.yml


 Want to learn more?
Visit the official knowledge base for Postgres MP:
https://docs.microfocus.com/itom/MP_for_PostgreSQL:1.10/postgres/Troubleshooting