How to connect Datagrip (or any intellij IDE) with Heroku Postgres
1 min readMay 17, 2018
Heroku Postgres forces you to use SSL, but the connection isn’t signed with a well-known CA. To get this to work in DataGrip, you have to mess around with some JDBC settings. Here’s how to do it:
In the add connections dialog, enter the username, password, hostname, port, and database name. You’ll have to enter these manually, because DataGrip’s URL support only works with JDBC database URLs, not the more common Postgres URLs used by Heroku.
Next, click on the Advanced tab. Then find the
sslproperty and set it totrue. Then find thesslfactoryproperty and set it toorg.postgresql.ssl.NonValidatingFactory.You should be good to go!
