Issue with Heroku Postgresql and database tools...

I keep getting "java.sql.SQLException: FATAL: no pg_hba.conf entry for host " when I use the database tool to connect to a Heroku postgres database.
After some searching I found this exact problem on Stackoverflow and the accepted answers says it has to do with Rubymine. Another answer suggests that it is possible to fix the issue by changing the postgres configuration.
I added a comment that the question was duplicate of another issue, but it might be a good idea to provide official pointers on how to solve the issue, and whether it is indeed Rubymine's issue or not.

1 comment
Comment actions Permalink

I found the answer to the issue here - it is not Rubymine at all.

TLDR:

add "?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory" to your jdbc string...
5

Please sign in to leave a comment.