Since updating to Node 14, none of my apps with a Postgres database will not connect anymore. I’ve run into this issue twice now…shame on me for not documenting the first time around! So I will troubleshoot again…
Some sleuthing reveals a database connection error…not sure why but my database error handling isn’t throwing errors. This issue suggests the issue is with
pg rather than Postgres or Sequelize.
pgto latest version. Minimal requirement is
8.0.3but as of now, the latest is
- Now at least a connection error throws:
Unable to connect to the database: ConnectionError [SequelizeConnectionError]: self signed certificate
- This issue confirms an issue with
pgand provides some additional settings to add to the database config:
And voila! Problem solved.