psql: server does not support SSL, but SSL was required

Question

Trying to connect to postgresql server using command prompt.

Command used:

psql "sslmode=require host=localhost dbname=test"

Error thrown:

psql: server does not support SSL, but SSL was required

Please help me out on this. Thanks.

Answer 1

This link suggests that you might try

psql "sslmode=disable host=localhost dbname=test"

or (probably better)

psql "sslmode=allow host=localhost dbname=test"

That way you should be able to connect to your server.