KNOWLEDGE BASE

Error "org.postgresql.util.PSQLException: Connection to localhost:8060 refused"


Published: 31 Aug 2016
Last Modified Date: 10 Jan 2017

Issue

Tableau Server logins fail and tabadmin commands that connect to the Internal Postgres database return the following error:

The driver encountered an unknown error: org.postgresql.util.PSQLException: Connection to localhost:8060 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Environment

Tableau Server 10.0

Resolution

Determine Tableau Server's current status by running tabadmin status -v from a command prompt. For more information, see tabadmin commands: status.
 
  • If tabadmin status is Stopped:
    1. Confirm that the Run As User has the necessary permissions described in Required Run As User Account Settings 
    2. Restart Tableau Server. 
  • If tabadmin status is Setting up, increase the timeout of the repository to 3 minutes:

    Open the Command Prompt as an administrator and run the following commands
    tabadmin stop
    tabadmin set clustercontroller.pgsql_connection_timeout_ms 180000 
    tabadmin config
    tabadmin start

     
  • If tabadmin status is Degraded

    Install the PostgreSQL drivers from Driver Download
     
  • If tabadmin status is Running

    A firewall or antivirus may be preventing Tableau Server from starting up completely. For more information, see Configuring Communication with the Internet

Cause

The Tableau Server Repository (Running on PosgreSQL) is unable to start. The Tableau Server Repository contains all the authentication information causing logins to fail. 

Additional Information

This issue may be resolved by installing/repairing the drivers installed on the computer running Tableau Server, however this is usually indicative of further problems that may need further investigation to reach a resolution.
Did this article resolve the issue?