Error "No pg_hba.conf entry for host 'xxx.xxx.xxx.xxx', user '<database user>', database '<database name>', no encryption." while configuring the PostgreSQL adapter in Aria Operations

Products

• VMware Aria Suite

Issue/Introduction

• The "Validate Connection" step during the PostgreSQL adapter configuration fails with an error: "No pg_hba.conf entry for host 'xxx.xxx.xxx.xxx', user '<database user>', database '<database name>', no encryption."
  
  
  
  
  
• In the /storage/log/vcops/log/adapters/PostgreSQLAdapter/PostgreSQLAdapter_xxxx.log you see messages similar to:

2025-02-12T06:48:40,147+0000 FATAL [Collector worker thread 23] (4751) com.bluemedora.exuno.DataProvider.fatal - Caught an ExUno exception while collecting: Collection failed when determining database list. Failed to initialize pool: FATAL: no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "<database user>", database "<database name>", no encryption
com.bluemedora.exuno.common.ExUnoException: Collection failed when determining database list. Failed to initialize pool: FATAL: no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "<database user>", database "<database name>", no encryption

Environment

VMware Aria Operations 8.x

Cause

This issue occurred because the destination PostgreSQL database is rejecting connections from the Aria Operations adapter for PostgreSQL

Resolution

The pg_hba.conf file for the target PostgreSQL instance needs to be configured to permit access for the credentials, host, and database specified in the Aria Operations Integration configuration for that endpoint.

Note: Please consult postgreSQL database administrator before making below changes to the pg_hba.conf file.

1. Login to postgreSQL database server.
2. Locate the pg_hba.conf File.
   The pg_hba.conf file is usually located in the PostgreSQL data directory, which is often /var/lib/pgsql/data/
3. Edit the pg_hba.conf file.
4. Add the following line to allow remote connections from all Aria Operations nodes IP addresses:
   

    # TYPE      DATABASE           USER        ADDRESS              METHOD
   host    <Database name>    <username>   <Aria Ops node IP>     md5

   • host: The connection type (use host for TCP/IP connections).
   • database: The name of the database or all to allow access to all databases.
   • user: The PostgreSQL user specified in the adapter configuration.
   • address: The IP address of the Aria Ops node. Use 0.0.0.0/0 to allow all IPs (not recommended for production). You should ideally specify the actual IP or range.
   • method: The authentication method (e.g., md5 for password-based authentication).
     
     Example:
     
      # TYPE      DATABASE     USER        ADDRESS              METHOD
   host      postgres   postgres     ariaops.example.com    md5
5. Restart PostgreSQL service.

    systemctl restart postgresql

Additional Information

For more information on configuring pg_hba.conf file