Table of Contents Previous Next

8 Server Configuration : 8.1 Modifying the pg_hba.conf File

Entries in the pg_hba.conf file control network authentication and authorization. The pg_hba.conf file on the PEM server host must allow connections between the PEM server and Apache/PHP, the PEM agent, and the monitored servers.
two
You may also need to manually modify the pg_hba.conf file to allow connections between the PEM server and other PEM components. For example, if your Apache/PHP installation does not reside on the same host as the PEM server, you must modify the pg_hba.conf file on the PEM server host to allowApache/PHP to connect to the server.
By default, the pg_hba.conf file resides in the data directory, under your Postgres installation; for example, on a PostgreSQL 9.3 host, the default location of the pg_hba.conf is:
You can modify the pg_hba.conf file with your editor of choice. After modifying the file, restart the server for changes to take effect. For information about restarting the server, see Section 8.2 (for Linux) or Section 8.3 (for Windows).
The following example shows a pg_hba.conf entry that allows an md5 password authenticated connection from a user named postgres, to the postgres database on the host on which the pg_hba.conf file resides. The connection is coming from an IP address of 192.168.10.102:
You may specify the address of a network host, or a network address range. For example, if you wish to allow connections from servers with the addresses 192.168.10.23, 192.168.10.76 and 192.168.10.184, enter 192.168.10.0/24 to allow connections from all of the hosts in that network.
For more information about formatting a pg_hba.conf file entry, please see the PostgreSQL core documentation at:

8 Server Configuration : 8.1 Modifying the pg_hba.conf File

Table of Contents Previous Next