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


  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 password, aligning these values under the parameter names in the row above.
      host   all     all  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.