6 Replies Latest reply on Jun 9, 2019 3:57 PM by paramasivan palanisamy

Unable to connect to PostgreSQL db

kbj3030 Nov 11, 2018 9:49 PM

Hi All,

I'm getting the below mentioned error when trying to connect to postgres db from Tableau Desktop post the upgrade from 2018.2.2 to 2018.3.0

Error 1: [ERROR] 11-05 19:00:01 - FATAL: Couldn't connect to repository, aborting (FATAL: no pg_hba.conf entry for host "xx.x.x.xxx, user "readonly", database "workgroup", SSL off

Tried the below link but was not helpful

https://kb.tableau.com/articles/Issue/error-no-pg-hba-conf-entry-for-host-connecting-to-server-repository

Below is my analysis

- Checked the firewalls and they were turned off

- Port is also fine.

- Done the pwd resets for both Tableau and read-only accounts

- checked whether the postgres db is enabled or not and its fine

- checked for pg_hba_conf file and it is not missing

Request you to suggest the needful. Thanks

Let me know if you need any additional details from my end. Thanks

1. Re: Unable to connect to PostgreSQL db

kbj3030 Nov 11, 2018 10:02 PM (in response to kbj3030)

Any idea how to repopulate pg_hba.conf file in Tableau 2018.3.0 version. If so, please give me the commands
Like Show 0 Likes(0)

Actions
2. Re: Unable to connect to PostgreSQL db

Toby Erkson Nov 13, 2018 6:51 AM (in response to kbj3030)

Are you able to connect to the db using another tool? Have you re-installed Desktop? Have you done any tinkering or changes directly to the TS PostgreSQL db?
I don't know what is happening. You will probably need to open a ticket with Tableau Support.
Like Show 0 Likes(0)

Actions
3. Re: Unable to connect to PostgreSQL db

kbj3030 Nov 15, 2018 2:58 PM (in response to Toby Erkson)

Hi Toby,

Nothing worked out. We have 3 environments sbx, qa and prod. We have upgraded sbx and qa to 2018.3 and but haven't upgraded prod yet. The point here is, we are not seeing any issue with prod but with both sbx and qa. Looks like its something with the upgrade. Do you have any inputs here?
Like Show 0 Likes(0)

Actions
4. Re: Unable to connect to PostgreSQL db

Steve Hennigh Jan 15, 2019 4:15 PM (in response to kbj3030)

We had similar issues when upgrading from Server 2018.1 to 2018.3. That broke some of the server statistics workbooks that we had on the server.

I had to download from our server any data sources (and workbooks with embedded data sources) that were connecting to the PostGres DB, edit them to 'require SSL' and then re-publish them to the server.
Like Show 0 Likes(0)

Actions
5. Re: Unable to connect to PostgreSQL db

kbj3030 Jan 17, 2019 6:45 AM (in response to kbj3030)

Hi All,

Thanks for the support. The issue got resolved when I did the password reset for readonly and tableau accounts. It allowed us to communicate to all servers without any issues.
Like Show 0 Likes(0)

Actions
6. Re: Unable to connect to PostgreSQL db

paramasivan palanisamy Jun 9, 2019 3:57 PM (in response to kbj3030)

how to reset the password? I am facing this on and off.
Like Show 0 Likes(0)

Actions