Release date: 2025-02-19
For migration instructions and recommendations, refer to Chapter 67.
PPEM 2.0 introduces the following functional upgrades:
Migration to Golang.
The manager and agents migrated to Golang, enhancing performance, scalability, and extensibility capabilities to handle increasing workloads and growing numbers of managed systems.
The new manager can serve a larger number of agents while consuming less memory and CPU resources. New agents also use less memory and CPU resources during routine operations.
Automatic resource detection.
Agents can now work in automatic detection mode. In this mode, an agent searches for DBMS instances, automatically registers them in PPEM, and continuously maintains up-to-date information about each DBMS instance.
Automatic detection and registration simplify PPEM deployment in environments with numerous instances and minimize manual operations required to add agents and database instances in PPEM.
Integration with pgpro-otel-collector.
pgpro-otel-collector is designed to collect metrics and activity logs from DBMS instances and send them to monitoring systems.
PPEM now integrates with pgpro-otel-collector, enabling the use of collector-gathered metrics for monitoring purposes. Integration can be performed in two ways:
PPEM receives metrics and logs from the collector via the OTLP protocol and stores them in the repository internal database.
PPEM is integrated with external log and metrics storage systems, allowing to get monitoring data from these sources. External storage integration allows PPEM to incorporate into existing monitoring infrastructure and use it for internal monitoring functions.
For more information, refer to Section 3.4.
API redesign.
The API was redesigned, with initial steps taken toward making it publicly available for broader use. The API is designed following REST standards, providing developers with a familiar framework to create, view, edit, and delete PPEM resources.
Future API publication will enable PPEM integration with automation systems, enhancing automated tools for DBMS infrastructure maintenance.