Working with replication clusters and integration with the BiHA failover manager.

The ability to work with streaming replication clusters is added. The PPEM web application now supports creating a cluster from an existing instance and displaying it in the corresponding section.

PPEM 2.1 takes the first step toward full BiHA cluster support. The new version displays existing BiHA clusters and provides functionality to remove nodes from an existing cluster.

Managing data sources.

In the Infrastructure → Data sources section of the PPEM web application, you can now create external storages for metrics and message logs collected via pgpro-otel-collector.

For metrics storage, PPEM supports integration with Prometheus, while for message log storage, it supports integration with Elasticsearch . Using external storage for metrics and logs is recommended because it reduces the load on the PPEM service repository by offloading additional data storage. It also eliminates the need for DBAs to perform additional scaling or closely monitor the PPEM service repository.

External storage systems are specifically designed to handle large volumes of specific data types and can be scaled and managed independently of PPEM.

For more information about configuring the integration, refer to Chapter 27.

Custom SQL metrics.

It is now possible to create and view metrics based on SQL statements planning and execution statistics collected by the pgpro_stats extension.

When creating or editing an SQL metric, the user can select a database, specify the user on behalf of which the query will be executed, and set the metric collection interval. The list of created metrics will be displayed on the page, and metric values can be viewed by clicking on the metric name.

Navigation panel redesign.

The navigation panel is redesigned based on user experience feedback from infrastructure and application DBAs.

Pages primarily intended for infrastructure DBAs are now grouped under the Infrastructure section, while the Databases section mainly used by application DBAs is promoted to the top navigation level for convenient and quick access to the database list.

Checking the consistency of an instance data directory.

The system now supports instance data directory verification using the checkdb command included in the pg_probackup extension. This command performs a physical verification of all data files in the directory, validating page headers integrity and verifying block-level checksums.

Adding the Console user role.

For flexible control over access to the psql web console, PPEM 2.1 introduces the Console user role. Now, only PPEM users with this role can access the psql console from the web application to perform database operations.

Installing and working with extensions.

It is now possible to install and work with extensions in the web application.

The DBMS instance navigation panel now includes the new Extensions section that displays the list of installed extensions that can be deleted, as well as the Install extension block for adding extensions to the specified databases.