PostgreSQL Configuration

Postgres Configuration

To allow connections from the APM Server to APM Connect, you must update the PostgreSQL networking configuration. This topic describes how to perform the configuration update.

Procedure

On the machine in which you installed APM Connect, navigate to your PostgreSQL installation files. The default location is
<root:>\Program Files\PostgreSQL\11\data.
Locate the configuration file pg_hba.conf, and then right-click the file and open it in a text editor.
Move through to the end of the document and locate the following line of text:
```
host all all 127.0.0.1/32 md5
```
Add a “host all all IP address of the APM Server md5” statement to the file.
Save the file and then close the text editor.

Note: For better security posture, it is recommended to restrict the PostgreSQL access to the APM Server only.

Results

PostgreSQL is now configured to open the connection from the APM Server.