Error: no pg_hba.conf entry for host SSL off

Questions and Answers
1

ANSWER: Add rejectUnauthorized following properly the PostgreSQL config documentation

The error appeared out of nowhere in a Heroku instance, so no idea on what triggered the error, the instance was heavely used for well over 1 month without any update.

Usefull links:

4 Likes
2

Thanks for posting this! Adding rejectUnauthorized indeed did save my Strapi app! Downtime for about 4h, took 2h fumbling around trying to fix until I saw your post here.

I dug further and found it it’s due to Heroku’s recent deprecation on some SSL endpoint -

11 Mar - SSL Endpoint Deprecation Schedule

23 Feb - All Heroku Postgres client connections require SSL

2 Likes