Allow Postgres without SSL?

[prashnts]

In my local dev setup, SSL is not enabled in PG. It throws this error, in this case:

usql pg://localhost/agoranhs
Type "help" for help.

pg:localhost/agoranhs=> select * from events limit 2;
error: pq: SSL is not enabled on the server
pg:localhost/agoranhs=> ^D

[kenshaw]

You need to pass the 'sslmode=disable' in the URL:

usql 'postgres://localhost/dbname?sslmode=disable'

This is due to the way that the lib/pq PostgreSQL driver handles SSL connections. Please see here: https://github.com/lib/pq

[berdon]

Can we add this to the readme.md? Otherwise this is pretty lost to newcomers.

[eadmaster]

another way to handle this would be appending an s in the protocol name (e.g. pgs)

[kid1412621]

You need to pass the 'sslmode=disable' in the URL:

usql 'postgres://localhost/dbname?sslmode=disable'

This is due to the way that the lib/pq PostgreSQL driver handles SSL connections. Please see here: https://github.com/lib/pq

is there anyway to disable it by default?