This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
A workflow that connects to a PostgreSQL database with Kerberos authentication runs OK locally on Designer, but when saving to the Gallery the following error is thrown:
Error SQLDriverConnect: FATAL: no pg_hba.conf entry for host 'IP_Address', user "username", database 'db_name', SSL off
The error indicates that there was a failed authentication attempt to the database, so the connection couldn't be established.The issue is a permissions-related issue on the user reported within the error message. This may be a 'Run As' user if one is set up on the Alteryx Server when publishing to the Gallery.
1. Check if the ODBC driver is configured correctly per the Simba PostgreSQL Configuration Guide. Step 10 has the configuration requirements for Kerberos.2. Consult the PostgreSQL admin to check the following: