PyCharm
 
Get PyCharm
You are viewing the documentation for an earlier version of PyCharm.

Connect to Heroku Postgres without SSL validation

Last modified: 20 September 2023

If you want to connect to Heroku Postgres, create a data source connection that corresponds to the data source vendor. In this case, you plan to work with PostgreSQL, so you need to create a connection to PosgreSQL. PyCharm already include the necessary JDBC driver.

Heroku Postgres requires you to use SSL for the connection. But for establishing a successful SSL connection, you need a certificate that you must upload to your Heroku application. SSL certificates are specific for each Heroku application. To configure these certificates, see the article about Heroku SSL.

If you do not plan to add the certificate in the keystore, you can bypass the server validation with the NonValidatingFactory option and establish an encrypted connection.