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.

For more information about pg_hba.conf, see http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html.

1

In the pg_hba.conf file, locate the line # TYPE DATABASE USER ADDRESS METHOD.

2

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 vCenter Hyperic server or any clients that need to query the database.

Create a vCenter Hyperic database user and database. See Create a vCenter Hyperic Database User and Database.