Thanks for using MS Q&A platform and posting your query.
The error message "28000: no pg_hba.conf entry for host ..., user ..., database ..., SSL off" indicates an issue with the access control configuration for your PostgreSQL database.
- Missing Configuration: The administrator of the PostgreSQL server might not have added an entry in the
pg_hba.conf
file to allow connections from your Azure Data Factory's IP address with the specified user and database. - Network Restrictions: If you're using Azure Database for PostgreSQL with Private Access (VNet integration), the standard connection method might not work. In this case, you'll need to use Secure Sockets Layer with Hostname Resolution (SHIR) for connections.
Here's how to troubleshoot the issue:
- Check with the PostgreSQL Server Administrator: If you don't have access to the server yourself, you'll need to contact the administrator and inform them about the error message. They can check the
pg_hba.conf
file and add an appropriate entry to allow access from your Azure Data Factory. - Verify Network Connectivity: Make sure your Azure Data Factory can reach the PostgreSQL server. If you're using Azure Database for PostgreSQL with Private Access, refer to the Azure documentation for connecting using SHIR: https://learn.microsoft.com/en-us/azure/postgresql/
- SSL/TLS Connection: If your PostgreSQL server requires TLS/SSL connections (which is on by default in Azure Database for PostgreSQL servers), you might need to ensure that your connection from Azure Data Factory is also using TLS/SSL
- Firewall Settings: Check if the IP address
40.74.27.93
is allowed through any firewalls that might be in place. This could be on the network level or configured in the Azure settings.
Hope this helps. Do let us know if you any further queries.