PyCharm
 
Get PyCharm

Create a PostgreSQL data source for Heroku Postgres without SSL validation

Last modified: 29 August 2024

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 PostgreSQL. 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 have to 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.