SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

[rpominov]

When running CLI without specifying any database connection options, it may crash with a confusing error (see title).

This is because this case is not handled well in node-postgres: brianc/node-postgres#1927 (comment)

Not sure whether we can do anything about this on our side

[DamithaPerera]

This works for me.

const dbConnection = new Client({ ssl: false, host: '127.0.0.1', port: 5432, database: 'test', user: 'postgres', password: 'test' })

[rpominov]

Sure. The problem is, if you do something like const dbConnection = new Client(); const connectionPromise = dbConnection.connect() the node process may crash, and you won't be able to catch the error as it won't be propagated through the connectionPromise.