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.

The path to the configuration file is /etc/ppem-manager.yml.

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.

In the /etc/ppem-manager.yml manager configuration file:

repo:
  url: "postgres://ppem:DBMS_user_password@localhost/ppem"

(Optional) To place database objects in a schema other than public used by default, in the /etc/ppem-manager.yml manager configuration file, specify the custom schema name using the repo.schema parameter:

repo:
  schema: "myschema"

The custom schema will be created automatically, or you can create it manually:

# sudo -u postgres psql -d ppem -c "CREATE SCHEMA myschema AUTHORIZATION ppem;"

Note that you can edit the repo.schema parameter only before starting the repository. If you decide to change the schema after that, you must recreate the repository database. This process does not automatically transfer existing database objects.

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

# systemctl start ppem
# systemctl enable ppem