The following error message is observed when trying to connect to a PostgreSQL database on UNIX/Linux from Strategy Intelligence Server 9.x -10.x.
Failed to connect to the datasource. Connect failed. No pg_bha.conf entry for 10.0.1.2xx for user "abc".
The pg_hba.conf file enables the client authentication between the PostgreSQL server and the client application (Strategy). This file consists of a series of entries, which define a host and its associated permissions including the database it is allowed to connect to and the authentication method to use. When PostgreSQL receives a connection request, it will check the pg_hba.conf file to verify that the machine from which the application is requesting a connection has rights to connect to the specified database.
The error message suggests that the Intelligence Server host and its permissions have not been defined in the pg_hba.conf file on the PostgreSQL database server.
The user must contact their Database Administrator and ensure that the Intelligence Server host details are added to the pg_hba.conf file.
