Cannot connect to Amazon Redshift

Error

[Amazon](500310) Invalid operation: no pg_hba.conf entry for host user SSL off;

More like,

[Amazon](500310) Invalid operation: no pg_hba.conf entry for host “::ffff:x.x.xxx.xxx”, user “the_user”, database “the_database”, SSL off;

 

In the Driver properties had to set

AuthMech=REQUIRE
SSL=TRUE

 

Yay, it worked!!

 

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *