Chapter 30. 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.
After installation, you can configure pgpro-otel-collector in one of the following ways:
Through the web application for each instance or cluster. This method simplifies configuration and does not require editing configuration files manually. For details, see Section 40.10 and Section 41.8.
Manually, by editing the pgpro-otel-collector configuration files on the server. This method offers more flexibility and is described below.
The manual configuration process includes the following steps:
Configure instance logging.
Ensure that values are specified for the following configuration parameters:
logging_collectorlog_destinationlog_directorylog_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.
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.
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.