Unable to connect. Error: no pg_hba.conf entry for host "52.175.251.223", user "doadmin", database "defaultdb", no encryption

App Building
#1

Hi
just start using retool
using postgresql and digitalocean i cannot connect to my database from retool
i have this error :Unable to connect. Error: no pg_hba.conf entry for host "52.175.251.223", user "doadmin", database "defaultdb", no encryption
thanks in advance

#2

Hello @yoopi,

have you configured your Database platform/system to allow Retools IP Addresses?

Here is a link to Retools Cloud IP Addresses

This article would help you configure this on DigitalOcean

#3

Hi
thx for reply
i did allow ip s of retools ..it says unable to connect no pg_hba.conf entry for the host means for retools

#4

Hello @yoopi,

When setting up the resource, please tick the SSL option, do let me know if that works for you