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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general