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

database ssl postgresql-9.5
Jyotirmay picture Jyotirmay · Apr 1, 2016 · Viewed 31.9k times · Source

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

enter image description here

Please help me out on this. Thanks.

Answer

Burki picture Burki · Apr 1, 2016

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.

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More