Postgres Pro Enterprise Manager : Documentation: 2: 26.3. Configure the Manager : Postgres Professional

26.3. Configure the Manager
Prev	Up	Chapter 26. Installation in Secure Environments	Home	Next

26.3. Configure the Manager #

On the Postgres Pro DBMS instance server:

Add the PPEM package repository:
1. Get the access key for the repository:
  1. Open your personal account in the technical support portal.
  2. Go to Administration → License Set → Repositories.
  3. Locate and copy the access key.
    Access keys are available only to license set administrators.
2. Download the pgpro-repo-add.sh Bash script:
```
wget --user 'access_key_value' --password='' https://repo.postgrespro.com/ppem/ppem/keys/pgpro-repo-add.sh
```
  Note
  Specify the access key value in --user, not --password. The latter option must be empty.
  This script adds the Postgres Pro repository so that the package manager of the host operating system can use it.
3. (Optional) Examine the content of the script, if necessary.
4. Make the script file executable and run it:
```
chmod +x pgpro-repo-add.sh && ./pgpro-repo-add.sh
```
  The script will install the Postgres Pro GPG keys, add the repository, and configure the package manager.
5. When prompted, enter the same access credentials as above:
  Important
  If no credentials are provided or they are invalid, the script offers to add the repository without credentials.
  If you proceed without credentials, you must manually provide the credentials later in order to access the repository.
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 example, to allow the manager to connect to the ppem repository database on behalf of the ppem user, the following HBA rules may be configured:
```
host    ppem  ppem  ::1/128       trust
host    ppem  ppem  127.0.0.1/32  trust
```
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:
- repo.url
  Specify the following value and substitute the necessary data:
```
postgres://ppem:DBMS_user_password@localhost/ppem
```
Configure the manager service to start under the operating system user:
1. Start editing the systemd unit:
```
# systemctl edit ppem
```
2. In the [Service] section, specify the name of the operating system user:
```
[Service]
User=ppem
```
3. Ensure that the operating system user is granted the privilege to read the ppem-manager.yml manager configuration file.
  If the privilege is not granted, execute:
```
# chown ppem:ppem /etc/ppem-manager.yml
# chmod 400 /etc/ppem-manager.yml
```
4. Save systemd unit parameters, then reload it:
```
# systemctl daemon-reload
```
Start the manager service and add it to the server startup:
```
# systemctl start ppem
# systemctl enable ppem
```

The web application will be installed on the server.

Prev	Up	Next
26.2. Creating Operating System Users	Home	26.4. Configuring Agents

epub pdf

26.3. Configure the Manager #

Note

Important