Finding your Tableau Server PostgreSQL database port

Ever have issues connecting to your Tableau Server PostgreSQL database due to a port issue? If so, you’re not alone! I too have struggled with this before and after hitting it just the second time I did some digging and fond how to determine the port of the Tableau Server PostgreSQL database. Here you go:

  1. Browse to your Tableau Server config location and open up this file:
    [install drive]:TableauTableau Serverdatatabsvcconfigconnections.yml
  2. Find the line in there showing the port “pgsql.port: XXXX”

Then when connecting to Tableau Servers PostgreSQL database you simply enter that value into the ‘port’ textbox in the connection form and viola!

Hope this helps!


  1. Thank you so much for sharing this! I was trying to hit the port my primary is on, which is just the default 80. When I tried to connect to port 80, Tableau just ran and ran (5+ minutes) without finding anything.

    Putting in the right port matters. I never knew about this connection file either.

  2. I am using default password and i am getting this error when i am connecting from one of the worker, thanks in advance. FATAL: password authentication failed for user “rails”

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.