0

I'm trying to push my local postgres db to heroku and I get the following SSL error:

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

I uninstalled postgres and reinstalled it with the configuration

./configure --with-includes=/usr/local/ssl/include

I also changed the ssl setting in my postgresql.conf file to "on" and sent a SIGHUP signal to the server and still get the same error.

Is there something I'm overlooking? I don't think it should be this difficult to push to heroku.

Improve this question
11
  • Please see the reason answered at: stackoverflow.com/a/36201845/6723862. Commented Sep 1, 2016 at 21:21
  • And in case you're running on OSX then for less headache and more for your convenience check out: postgresapp.com :) Commented Sep 1, 2016 at 21:25
  • @KristoMagi I did see that answer. I thought reinstalling postgres and configuring my setup with ./configure --with-includes=/usr/local/ssl/include would result in my libpq library being configured correctly to work with openssl. Commented Sep 1, 2016 at 21:30
  • Might be then that you need to add --with-openssl and --with-includes=/usr/local/ssl/include/openssl flag – NB: check also folders. For another question what OS are you running and what did you use to install Postgres? Commented Sep 1, 2016 at 21:40
  • @KristoMagi I'm using OS X. I installed postgres by downloading the source and following the instructions in the documentation. I tried configuring my install by doing --with-openssl but got the error "configure: error: header file <openssl/ssl.h> is required for OpenSSL". So i tried the solution here: postgresql.org/message-id/[email protected] Commented Sep 1, 2016 at 21:43
Related questions
3
PGError: SSL connection failure, H10 error
1
Postgres + Heroku SSL SYSCALL error
1
Postgres SSL connection failing to be established
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.