Configuring PostgreSQL database connection
The PATROL for PostgreSQL KM must have access to the PostgreSQL database to retrieve the data that is reported in the Patrol console, TrueSight console, or BMC Helix Operations Management.
If you receive the following error, the connection between the KM and the database failed because Agent host cannot reach the PostgreSQL database host.
connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "xX.XXX.XX.XXX", user "XXX", database "XXX"
To configure the database so it recognizes the user name, you need to add the following first line of the pg_hba.conf file that is located at .../PostgreSQL/%version%/data. Before you make this change, you must stop the database's service.
host all all 0.0.0.0/0 md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
After you have made the change, you must restart the PostgreSQL service.
This change allows all of the users from all of the hosts to access the database host.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*