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!

5 Comments

  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.