KNOWLEDGE BASE

Error "no pg_hba.conf entry for host" Connecting to Tableau Server Repository


Published: 21 Jan 2016
Last Modified Date: 12 Sep 2016

Issue

When connecting to the Tableau Server PostgreSQL repository from Tableau Desktop, the following error might occur:

FATAL: no pg_hba.conf entry for host "xxxx.xx.xxx.xxx", user "readonly", database "workgroup", SSL off.

Environment

  • Tableau Desktop
  • Tableau Server with SSL enabled
  • PostgreSQL

Resolution

When connecting to Tableau Server's PostgreSQL database from Tableau Desktop, ensure that Require SSL is selected.

Cause

When Tableau Server is set to require SSL for all connections, Tableau Desktop must use SSL in order to connect to the repository.
Did this article resolve the issue?