KNOWLEDGE BASE

Connecting to PostgreSQL Version 12 Databases

Published: 13 May 2020
Last Modified Date: 08 Jul 2022

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 xxxxxx 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?    
PRINT THIS PAGE
Trending Articles
Attachments


All Support

SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
INFORMATION
ASSISTANCE