KNOWLEDGE BASE

Error While Connecting to Postgres Using JDBC driver


Published: 31 Jan 2022
Last Modified Date: 31 Jan 2022

Issue

Unable to connect to Postgres from Tableau Desktop 2021.2.8. Other applications (Dbeaver) work fine.

Error Message: 

Bad Connection: Tableau could not connect to the data source.
 ['There was an internal error.', 'Unable to connect to the PostgreSQL server "POSTGRES-DB.SERVER.LOCAL". Check that the server is running and that you have access privileges to the requested database.']

Environment

  • Tableau Desktop 2021.2.8
  • Mac OSX (Other)
  • PostgreSQL

Resolution

Use the ODBC driver instead of the JDBC

Cause

Error while running the Postgres JDBC driver.

Additional Information

You may see the following messages in the logs:
 
"Failed to read from port file."

"Error starting Java Protocol Server. Couldn't read socket or port."
 
Did this article resolve the issue?