java.sql.SQLException: FATAL: no pg_hba.conf entry for host

Question

Developing RoR app on Windows using RubyMine, trying to connect to Postgres database hosted on Heroku server. No Postgres installed locally. Getting "java.sql.SQLException: FATAL: no pg_hba.conf entry for host..." What to do, what to do?

Answer 1

This is due to Heroku databases needing additional SSL configuration. You need to enable SSL in your jdbc string by appending:

?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

For details see Heroku's help document.