1

I install postgresql in my ubuntu Server 18.04 LTS, and I want it support OpenSSL.

  1. I do the lengthy way with PostgreSQL source code installation, where I can select the openssl feature:
 ./configure –with-openssl
  make
  make install
  ldconfigure
  1. Upon installing the Ubuntu server I can select with the help of tasksel PostgreSQL to be installed, or using the apt-get postgresql-10 postgresql-contrib

Does the 2nd way configure PostgreSQL to add the feature of openssl (be SSL ready)?

enter image description here

  • AFAIK it does. But why don't you just try it? In any case, you will need a certificate, too - read postgresql.org/docs/current/static/ssl-tcp.html – dezso Jul 24 '18 at 17:17
  • @dezso...I tried 1st & created crt for server & client. In chapter 16 if you install from deb package it doesn't tell weather its pre configured or no.. Thanks for the reply. – Mohd Jul 24 '18 at 17:50
  • @dezsi...and it seems easy to install from deb rather than lengthy 1st way :) – Mohd Jul 24 '18 at 17:52
1

You can try pg_config with --configure flag.

--configure

Print the options that were given to the configure script when PostgreSQL was configured for building. This can be used to reproduce the identical configuration, or to find out with what options a binary package was built. (Note however that binary packages often contain vendor-specific custom patches.)

And confirm whether the installed version has SSL enabled or not!

  • @hjpotter92...ok after fresh installation of Ubuntu 18.04 LTS server, then installling the postgresql-10 postgresql-server-dev-10 postgresql-client-10 & contrib & libpq-dev .. – Mohd Jul 25 '18 at 13:43
  • @hjpotter92...I ran the pg_config command and the result in the question area up...what can you tell of that ? – Mohd Jul 25 '18 at 14:09
  • @Mohd You see the --with-openssl flag in the output of the command? That means it was compiled with ssl support. :) – hjpotter92 Jul 25 '18 at 16:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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