Beej
Beej

Reputation: 130

Cannot access Heroku postgres from CLI, SSL support issue

I'm having trouble connecting to my Postgres database on Heroku. I run heroku pg:psql from the terminal, and get the error:

psql: sslmode value "require" invalid when SSL support is not compiled in

All the instances I find of this error online are php related, and it's only started acting up recently. Anybody know what's up with this?

Upvotes: 4

Views: 672

Answers (1)

Will
Will

Reputation: 2951

Your local psql binary was not compiled with SSL support. You will need to locally recompile (or otherwise acquire for your os a binary of) postgres with SSL.

Upvotes: 1

Related Questions