Unable to access Heroku posthertz from CLI, SSL issue

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

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

All instances that I find in this error on the Internet are php related, and this has only just begun to work lately. Does anyone know what is wrong with this?

+4
source share
1 answer

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

+1
source

All Articles