current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
up vote 0 down vote favorite

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.

share|improve this question
    
Please see the reason answered at: stackoverflow.com/a/36201845/6723862. – Kristo Magi 22 hours ago
    
And in case you're running on OSX then for less headache and more for your convenience check out: postgresapp.com :) – Kristo Magi 22 hours ago
    
@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. – Brosef 22 hours ago
    
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? – Kristo Magi 22 hours ago
    
@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] – Brosef 22 hours ago

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.