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:
- Browse to your Tableau Server config location and open up this file:
[install drive]:TableauTableau Serverdatatabsvcconfigconnections.yml
- 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!