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@aklaver.com