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;"

It is sufficient to specify the schema name for a fresh installation of PPEM when no services are running.

Changing the schema name on a running PPEM installation with multiple existing objects requires following a more complex procedure.

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

# systemctl start ppem
# systemctl enable ppem