KNOWLEDGE BASE

"An Error Occurred While Communicating With The PostgreSQL Database Data Source 'workgroup'." Connecting to Tableau Server PostgreSQL


Published: 07 Apr 2015
Last Modified Date: 08 May 2017

Issue


When a user tries to connect to the Tableau Server PostgreSQL database from Tableau Desktop, the following error occurs:
 
An Error Occurred While Communicating With The PostgreSQL Database Data Source 'workgroup'.
Unable to connect to the server. Check that the server is running and that you have access priviliges to the requested database.

Could not connect to the server;
No connection could be made because the target machine actively refused it. [IP address:8060]

Unable to connect to the server "[Server Address]". Check that the server is running and that you have access privileges to the requested database.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Server
  • Tableau Desktop
  • Distributed Environment

Resolution

Verify which computer is running the PostgreSQL database:
  1. Log into Tableau Server as an administrator. 
  2. Open the status screen of Tableau Server. See View Server Process Status for more information.
  3. Check which nodes have the repository process. Use the value (worker 1, worker 2, etc.) to determine the correct computer to connect to.

Cause

Only the computer hosting the active repository can be connected to port 8060.
Did this article resolve the issue?