Deploy on Heroku+postgres fails due to lack of SSL support

[gheja]

When deploying to Heroku i get

original: error: no pg_hba.conf entry for host "54.227.xxx.xxx", user "xxx", database "xxx", SSL off
at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.<anonymous> (/app/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:394:28)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228:10)
at TCP.onStreamRead (node:internal/stream_base_commons:199:23) {

It looks like the Heroku's postgres database requires an SSL connection but Sequelize is not using it by default.

Adding the following in lib/storage.js tells Sequelize to always use SSL (which might not be the ideal solution):

const sequelize = new Sequelize(url, { logging: false });

const sequelize = new Sequelize(url, { logging: false, dialectOptions: { ssl: { require: true, rejectUnauthorized: false } } });