Resolving "28000: no pg_hba.conf entry for host" Error in Bold BI with PostgreSQL Data Source
Resolving “28000: no pg_hba.conf entry for host” Error in Bold BI with PostgreSQL Data Source
When attempting to create a new PostgreSQL data source in Bold BI, you may encounter the error message “28000: no pg_hba.conf entry for host.” This error indicates that the PostgreSQL server has restricted permissions for external connections. To resolve this issue, follow the steps outlined below.
Steps to Resolve Connection Issues
1. Verify Credentials and Authentication Method
Ensure that you are using the same credentials and authentication method in both Bold BI and other PostgreSQL tools like pgAdmin. The credentials include the username and password, and the authentication method might be password-based or another supported method.
2. Whitelist IP in PostgreSQL Configuration
Check your PostgreSQL configuration files to confirm that the IP address from which you are trying to connect is whitelisted. The pg_hba.conf file controls which hosts are allowed to connect, the methods of authentication allowed, and the databases they can access.
For more information on how to configure the pg_hba.conf file, please visit the official PostgreSQL documentation:
PostgreSQL: Client Authentication
3. Enable SSL if Required
If your connection to the PostgreSQL server requires SSL, you must enable it in the Bold BI data source settings. You can find instructions on how to enable SSL through connection parameters for a PostgreSQL data source at the following link:
How to enable SSL through connection parameters for PostgreSQL data source in Bold BI
Conclusion
By verifying the credentials, whitelisting the IP address, and enabling SSL if necessary, you should be able to resolve the “28000: no pg_hba.conf entry for host” error and successfully create a new PostgreSQL data source in Bold BI.
Additional References
