KNOWLEDGE BASE

Connecting to PostgreSQL Version 12 Databases


Published: 13 May 2020
Last Modified Date: 15 Feb 2021

Issue

When connecting to a PostgreSQL Version 12 Database from Tableau Desktop or any other Tableau Products, you may encounter issues such as "Unknown Error (followed by gibberish text) or Error: Current Transaction is Aborted, Commands Ignored Until End of Transaction Block."

Environment

  • Tableau Desktop
  • Tableau Prep Builder
  • Tableau Server
  • Mac OS + Windows OS

Resolution

Option 1
Continue to use PostgreSQL Version 11 or lower if possible.

Option 2
Upgrade to Tableau 2020.4 or higher and use the JDBC driver. Refer to the Driver Download page for additional details (https://www.tableau.com/support/drivers)
 

Cause

PostgreSQL version 12 is not supported in Tableau product versions prior to 2020.4.
Did this article resolve the issue?