PostgreSQL client authentication is defined in the pg_hba.conf file, which contains records that specify allowed connection types, users, client IP addresses, and the authentication method.
About this task
For more information about pg_hba.conf, see http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html.
- In the pg_hba.conf file, locate the line
# TYPE DATABASE USER ADDRESS METHOD.
- Immediately below the located line, add
host all all 0.0.0.0/0 password, aligning these values under the parameter names in the row above.
# TYPE DATABASE USER ADDRESS METHOD host all all 0.0.0.0/0 password
You can use the address parameter to limit access to just the vRealize Hyperic server or any clients that need to query the database.
What to do next
Create a vRealize Hyperic database user and database. See Create a vRealize Hyperic Database User and Database.