Thread: [GENERAL] enable PostgreSQL SSL from RPM package installation

Am 22. Juni 2017 08:10:15 MESZ schrieb Dylan Luong <Dylan.Luong@unisa.edu.au>:
>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?
>
>Thanks.
>
>Regards
>Dylan


Yes, it is compiled with SSL.

Regards, Andreas


--
2ndQuadrant - The PostgreSQL Support Company

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