KNOWLEDGE BASE

Error "no pg_hba.conf entry for host" After Attempting to Refresh a Redshift Extract on Tableau Online


Published: 24 May 2017
Last Modified Date: 20 Sep 2017

Issue

When refreshing Redshift extracts or opening workbook that use live Redshift connections on Tableau Online, the following error might occur:
[Amazon][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] FATAL:  no pg_hba.conf entry for host "IP ADDRESS", user "USERNAME", database "DATABASE NAME", SSL off

Environment

  • Tableau Online
  • Amazon Redshift

Resolution

Upgrade to Tableau Desktop 10.3.3 ; 10.2.5 or 10.1.11. For more information, see Upgrading Tableau Desktop in Tableau Help.

Cause

This behavior is related to a known issue (ID: 652691) that has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?