Unable to retrieve remote data connecting to postgresql database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Remote call Failed.

Unable to retrieve remote data. 

Message: Profile failed verification due to error (1) error, Failed to connect to the PostgreSQL Environment
Error Code: VM-001

From the postgresql probe log:

Nov 19 23:38:34:034 [attach_socket, postgresql] Failed to connect to database : FATAL: no pg_hba.conf entry for host "##.##.##.##", user "postgres", database "postgres", no encryption 
Nov 19 23:38:34:035 [attach_socket, postgresql] Error connecting to postgresql database :FATAL: no pg_hba.conf entry for host "##.##.##.##", user "postgres", database "postgres", no encryption 
Nov 19 23:38:34:035 [attach_socket, postgresql] org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "##.##.##.##", user "postgres", database "postgres", no encryption 

Environment

Version: 20.4, 23.4
Component: postgresql probe

Cause

The pg_hba.conf does not have an entry allowing the IP listed in the message to access the database, and with what type of authentication.

Resolution

Update the pg_hba.conf with the address that needs to connect.

example:

host    all             all             ##.##.##.##/32       password

Note: The method should be set to 'password' as the probe currently only supports non-SSL connections.