Troubleshooting Postgres SQL MP

  • KM03637096
  • 30-Apr-2020
  • 30-Apr-2020

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