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 PEM-HTTPD, the PEM agent, and the monitored servers.
You may also need to manually modify the pg_hba.conf
file to allow connections between the PEM server and other components. For example, if your PEM-HTTPD 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 allowPEM-HTTPD to connect to the server.
By default, the pg_hba.conf
file resides in the data
directory, under your Postgres installation; for example, on an Advanced Server 10 host, the default location of the pg_hba.conf
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.
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