We have been evaluating the dbForge studio as a solution for maintaining the databases and schemas in our DWH, which is Amazon Redshift.

According to documentation, dbForge studio for Postgres should be able to connect to Redshift (as Redshift is postgres-based), however this does not seem to work for us. Namely, upon trying to create a connection to Redshift we get:

no pg_hba.conf entry for host "???", user "dwhadmin", database "dev", SSL off

Our setup is:

- Redshift in Private Subnet

- AWS NLB in front exposing the DWH

- All security groups properly configured (we can access the DWH with psql)

- SSL is not a problem

Any ideas are more than welcome. Thanks in advance for your help.