Re: enable PostgreSQL SSL from RPM package installation

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(dot)klaver(at)aklaver(dot)com