4.4. Installation and Configuration of Logging and Monitoring Tools #

Logging of DBMS instances and working with their metrics is done in PPEM using pgpro-otel-collector manually installed on all servers.

For more information, refer to the official Postgres Pro documentation on installing pgpro-otel-collector.

You must manually configure the installed pgpro-otel-collector. The configuration process includes the following steps:

  1. Configure instance logging.

    Ensure that values are specified for the following configuration parameters:

    • logging_collector

    • log_destination

    • log_directory

    • log_filename

    Instance logging must be done in the CSV or JSON format.

    For more information, refer to the official Postgres Pro documentation on server configuration.

  2. Configure pgpro-otel-collector to collect instance logs and metrics.

    For more information, refer to the official Postgres Pro documentation on configuring logs and metrics for pgpro-otel-collector.

  3. Configure pgpro-otel-collector to send instance logs and metrics to PPEM or an external storage.

    For more information, refer to the official Postgres Pro documentation on integrating pgpro-otel-collector with PPEM.

    Important

    Local storages are intended for introductory use with PPEM. For production environments with a large number of instances and metrics, it is recommended to use external storages.