KNOWLEDGE BASE

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


Published: 24 May 2017
Last Modified Date: 05 Dec 2017

Issue

When refreshing Redshift extracts or opening a workbook that uses a live Redshift connection, 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 Desktop 10.1.0 to 10.1.10, 10.2.0. to 10.2.4, 10.3.0 to 10.3.3
  • Tableau Server 10.1.0 to 10.1.10, 10.2.0. to 10.2.4, 10.3.0 to 10.3.3
  • Amazon Redshift

Cause

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