From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kido Kouassi <jjkido@gmail.com>
cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Yum Install postgresql93 with SSL
In-reply-to: <548F2427.2060102@gmail.com>
References: 
 <CA+ebzumSN0UG+JhWvGjuqC2a8RDf84yew8z8cqg=P7GWLTFXvw@mail.gmail.com>
 <548F2427.2060102@gmail.com>
Comments: In-reply-to John Scalia <jayknowsunix@gmail.com>
 message dated "Mon, 15 Dec 2014 13:10:47 -0500"
Date: Mon, 15 Dec 2014 13:17:53 -0500
Message-ID: <13394.1418667473@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

> On 12/15/2014 12:58 PM, Kido Kouassi wrote:
>> 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.

I'd bet this has nothing to do with SSL and lots to do with the "change
ownership" step.  You sure you did that right?

			regards, tom lane


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