Re: Yum Install postgresql93 with SSL - Mailing list pgsql-admin

From John Scalia
Subject Re: Yum Install postgresql93 with SSL
Date
Msg-id 548F2427.2060102@gmail.com
Whole thread Raw
In response to Yum Install postgresql93 with SSL  (Kido Kouassi <jjkido@gmail.com>)
Responses Re: Yum Install postgresql93 with SSL
Re: Yum Install postgresql93 with SSL
List pgsql-admin
Not absolutely certain, but you may need to use an explicit path to those SSL files. Something like "/var/lib/pgsql/9.3/data/server.crt", etc...

--
Jay

On 12/15/2014 12:58 PM, Kido Kouassi wrote:
Hello Admins,

I am looking to Install PostgreSQL using the Yum Install on CentOS 6 With support for SSL but is is not working.

My question is: am I doing it wrong or the only way to have SSL support is to build from source?

Here is what I did:

I used the following sequence to install

1- yum install postgresql93-server.x86_64 postgresql93-jdbc.x86_64 postgresql93.x86_64 postgresql93-contrib.x86_64 postgresql93-pltcl.x86_64 postgresql93-plpython.x86_64 postgresql93-odbc.x86_64 postgresql93-libs.x86_64

2- service postgresql-9.3 initdb

3- service postgresql-9.3 start

at the first try database started with no issue,

then I copied the Cert and keys files, to the data folder,

modified the postgresql.conf with

ssl = on      
#ssl_ciphers = 'DEFAULT:!LOW:!EXP:!MD5:@STRENGTH'      
                      
#ssl_renegotiation_limit = 512MB   
ssl_cert_file = 'server.crt'     
ssl_key_file = 'server.key'  
ssl_ca_file = 'root.crt'             
#ssl_crl_file = ''

After this I change ownership of the whole data folder to postgres user and restarted the service.


1- The service did not start

2- Nothing was logged in the log file.



Thank you in advance for your help,


--Kido K                


pgsql-admin by date:

Previous
From: Kido Kouassi
Date:
Subject: Yum Install postgresql93 with SSL
Next
From: Tom Lane
Date:
Subject: Re: Yum Install postgresql93 with SSL