On 06/21/2017 11:10 PM, Dylan Luong wrote:
Hi
I have installed PostgreSQL from the following RPMs onto the server. And
I would like to enable SSL.
postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64
postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64
postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
postgresql96-server-9.6.2-2PGDG.rhel7.x86_64
postgresql96-9.6.2-2PGDG.rhel7.x86_64
From the PostgreSQL documentation,
https://www.postgresql.org/docs/current/static/ssl-tcp.html it says
that PostgreSQL SSL support needs to be enable at build time.
Just wondering if these RPMs are compiled with SSL enabled?
You can use pg_config:
https://www.postgresql.org/docs/9.6/static/app-pgconfig.html
So, on my machine with source compiled Postgrse:
pg_config --version --configure
PostgreSQL 9.6.3
'--with-python' '--with-openssl' '--with-libxml'
'--prefix=/usr/local/pgsql96'
If you have more then one version of Postgres installed then you will
need to use the pg_config from that version:
/usr/local/pgsql94/bin/pg_config --version --configure
PostgreSQL 9.4.11
'--with-python' '--with-openssl' '--with-libxml'
'--prefix=/usr/local/pgsql94'
Thanks.
Regards
Dylan
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
