Postgres Database Connection Issues (SSL off)

Issue

Having issues connecting to your database and you keep seeing messages regarding ssl in the logs similar to:

error: no pg_hba.conf entry for host "XX.XXX.XXX.XX", user "userfoo", database "dbfoo", SSL off

Resolution

Are you enforcing ssl to connect to the database? There was a recent change which requires the use of ssl now; https://devcenter.heroku.com/changelog-items/2035

A lot of clients automatically connect using ssl, but not all and those that don't need to force ssl to be used. Further info: https://devcenter.heroku.com/articles/heroku-postgresql#heroku-postgres-ssl

Keeping up to date with changes on a big platform like Heroku isn’t always easy, but we recommend subscribing to the Heroku Changelog if you aren’t already. This will let you know about updates like this, improvements and deprecations ahead of time so that you can make any necessary changes.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support
Terms of Service Privacy Cookies © 2021 Salesforce.com