[Solved]-How to connect PyCharm to a Heroku postgres database

by

22👍

✅

There is no need to configure the files. Just append the following to the automatically generated url:

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

So the correct url will be:

jdbc:postgresql://host:port/database?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

It does not seem to matter if you check SSL or not. The param ssl=true will force an ssl connection.

👤Arctelix

Leave a comment