Add the PPEM package repository:

# wget -O pgpro-repo-add.sh https://repo.postgrespro.ru/ppem/ppem/keys/pgpro-repo-add.sh
# sh pgpro-repo-add.sh

Install the manager:

# apt install ppem ppem-gui

The ppem-manager.yml manager configuration file will be downloaded to your local device.

Create the DBMS user on behalf of which the manager will connect to the repository database:

# sudo -u postgres createuser --pwprompt ppem

When executing this command, specify the DBMS user password.

Create the repository database:

# sudo -u postgres createdb -O ppem ppem

Ensure that the DBMS user can connect to the database:

# psql -h localhost -U ppem -d ppem

In case of connection issues, ensure that the HBA rule allowing the DBMS user to connect to the database, as well as the authorization method, are specified in the pg_hba.conf configuration file.

For more information, refer to the official Postgres Pro documentation on the pg_hba.conf configuration file.

While connected to the ppem repository database on behalf of the ppem user, grant the DBMS user the privilege to read the pg_statistic system catalog:

GRANT SELECT ON pg_catalog.pg_statistic TO ppem;

In the ppem-manager.yml manager configuration file:

Configure the manager service to start under the operating system user:

Start the manager service and add it to the server startup:

# systemctl start ppem
# systemctl enable ppem