Error: The server does not support SSL connections

[diegodp-zz]

hello, i am getting this error when trying to deploy in hostinger.
i use this
module.exports = {
projectConfig: {
database_extra:
process.env.NODE_ENV !== "development"
? { ssl: { rejectUnauthorized: false } }
: {},
// ...
},
// ...
}

but the error persist

[diegodp-zz]

I find the problem, i needed to configure the postgres to be SSL on

If someon have the same problem with me, i have followed these instructions and worked.
https://www.howtoforge.com/how-to-enable-ssl-for-postgresql-connections/

[fxck]

I think this is still a valid errors, something is not right, I have both ssmode=disable in DATABASE_URL as well as

    databaseDriverOptions: {
      connection: {
        ssl: {
          rejectUnauthorized: false
        }
      }
    },

in config, yet I'm still getting "The server does not support SSL connections"

[oklenum]

I had a typo in the connection string...
sslmode=disable -> ssl_mode=disable
Fixed it for me 🙃

[fxck]

The correct param would be sslmode (https://www.postgresql.org/docs/current/libpq-ssl.html), but from what I found the problem was actually rejectUnauthorized: false, contrary to what the docs say, it should not be defined at all.

So if you want to disable SSL, do a combo of ssl_mode=disable + no databaseDriverOptions whatsoever.