![External User - Yaswanth Gampala (Customer)](https://community.tableau.com/img/userprofile/default_profile_45_v2.png)
Yaswanth Gampala (Member) asked a question.
Hello Tableau Community,
I’m encountering an issue while trying to connect Tableau to a PostgreSQL 16 database. I am able to connect successfully to PostgreSQL 15, but whenever I attempt to connect to PostgreSQL 16, I receive the error code `1F96A837`.
I’m using the following setup:
- Tableau Version: 2024.2.1
- PostgreSQL Version: 16
To troubleshoot, I’ve taken several steps. I’ve double-checked the credentials for PostgreSQL 16, ensuring that the username, password, and host settings are correct. I also installed the latest ODBC/JDBC drivers for PostgreSQL, but the issue persists. I can connect to PostgreSQL 15 with the same Tableau configuration, so it appears to be specific to version 16.
I’ve also verified that PostgreSQL is properly configured to allow remote connections and that the `pg_hba.conf` file is set up correctly. Additionally, I checked for any potential firewall or antivirus issues, but nothing seems to be blocking the connection.
Despite these efforts, I continue to encounter the error code `1F96A837`, and I haven’t found much documentation on this particular error in relation to PostgreSQL 16.
I’d appreciate it if anyone has encountered similar issues with PostgreSQL 16 and Tableau. Is there a known compatibility issue, or are there any configuration changes I might be missing? Also, if there are any specific driver versions that work better with PostgreSQL 16, I would be glad to know.
Any insights or suggestions would be greatly appreciated!
Thanks in advance.
Hi @Yaswanth Gampala (Member) ,
You have the answer on the first line of your error message: "Invalid value for parameyter "TimeZone":"Asia/Calcutta".
Apparently Postgres has updated the timezone to "Asia/Kolkata", at least according to this post
https://community.tableau.com/s/question/0D58b0000Ar3DqVCQU/hi-tableau-do-not-let-me-extract-my-data-when-i-extract-my-data-i-get-following-error-could-you-help-me-pleasesqlstate58p01-cannot-create-temp-database-the-transient-database-could-not-be-createdunable-to-create-extract
It is a bug for DBeaver, but the reason seems to be the same.
Can you change the parameter value somehow? If not, then you will need to contact Tableau support to get this fixed in Tableau.
Please mark this answer as best if I helped you solve your problem