Resolving "28000: no pg_hba.conf entry for host" Error in Bold Reports with PostgreSQL Data Source
When attempting to create a new PostgreSQL data source in Bold Reports, 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 Reports 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
Conclusion
By verifying the credentials and whitelisting the IP address, 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 Reports.
