Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I recently tried to upgrade my postgresql from 9.0 to 9.1. I got to a point where I was able to get both builds to run concurrently (on different ports). Then I tried copying some settings from the old config file into the new one, and one of the settings was setting SSL to enabled. This by itself is alright, but unfortunately, back when I first built the build, I forgot to configure it with SSL. And as such, I get the following error when I try to start up the server: FATAL: SSL is not supported by this build.

So, can I add SSL support to an already built and installed Postgresql? Or, am I going to have to delete stuff, reconfigure the build, remake it and finally re-install it?

Also, could someone tell me how to set it up correctly. For example, at the moment, if I use the psql command in the terminal, it uses the old psql (i.e. the 9.0's psql), and if I want to use of any the new commands (i.e. 9.1's commands), I have to write out a full directory, like this: /usr/local/pgsql/bin/postgres -D /var/lib/postgresql/9.1/main -p 5433. It would also be nice to know how to have postgresql start up on boot time.

Thanks a lot for the help, I know my questions are a bit simplistic, but I am still getting used to linux development and administration.

share|improve this question
One question per question, please. – Peter Eisentraut Oct 12 '11 at 18:29
Sorry about that, I will remember that next time. Should I post the second part as a new question after I have figured out the first? – zermy Oct 12 '11 at 18:56
up vote 1 down vote accepted

In order to add SSL support to your installation, you need to rerun the configure, make, make install sequence with the appropriate options. But you don't have to delete anything. Just install the new binaries over the old ones and restart the server.

share|improve this answer
I see, thanks a bunch, so does the re-install replace all the data and config files as well? i.e. Will I have to remake the data cluster? – zermy Oct 12 '11 at 18:42
Data and config files are not affected by the program installation. – Peter Eisentraut Oct 13 '11 at 4:01

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.