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/connecting-heroku-postgres#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.