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

19.3. Configure the Manager
Prev	Up	Chapter 19. Installation in Secure Environments	Home	Next

19.3. Configure the Manager #

On the Postgres Pro DBMS instance server:

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.
In the ppem-manager.yml manager configuration file:
- Specify the repository database name using the repo.name parameter:
```
repo:
  name: "ppem"
```
- Specify the DBMS user name and password using repo.user and repo.password parameters:
```
repo:
  user: "ppem"
  password: "DBMS_user_password"
```
- Specify the URL for connecting the manager to the repository database using the repo.url parameter:
```
repo:
  url: "postgres://ppem:DBMS_user_password@localhost/ppem"
```
  For more information about the URL format, refer to the official Postgres Pro documentation on connection strings.
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
19.2. Creating Operating System Users	Home	19.4. Configuring Agents

epub pdf