Postgresql over ssl, trying to connect to Heroku postgresql database from studio

Support
#1

Hello,

I’m trying to connect to a postgresql datastore on Heroku, but I always get the following error message:

15:40 Error Connecting to Database: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “213.126.41.226”, user “wacmuedygukiln”, database “d5p962rsam59ds”, SSL off

My setting look like this:

2019-08-01%2015_43_06-Window

Strange thing is that my sslmode does not seem to matter… :frowning:

Anyone who has succeeded? Thanks for your help!

#2

Never mind, I just figured it out… :wink:

Happy to share the solution:

2019-08-01%2015_51_10-Window

Apparently just a matter of selecting to set a custom database url and add ‘?sslmode=require’ at the end to the url.

Hope this helps someone else figuring out how to get it up and running.