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.

Procedure

  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 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.