PostgreSQL SSL Connection on EC2

felix Registered Posts: 2 ✭✭✭✭

I deployed Dataiku on an EC2 instance, it looks great!

Unfortunately, I can't connect to my Heroku PostgreSQL database because it forces the use of SSL.

How can I enable SSL for the PostgreSQL JDBC driver?

I have very little knowledge about servers beside ssh-ing into a machine.

I found this doc but I'm not even sure it's related at all:

(here we just want the driver to connect through SSL not setup SSL for postgres I guess)

[Copy/Pasting the error message here to be referenced in Google when someone has the same issue: FATAL: no pg_hba.conf entry for host "....", user "...", database "...", SSL off]


Best Answer


Setup Info
      Help me…