Re: Yum Install postgresql93 with SSL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kido Kouassi <jjkido(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Yum Install postgresql93 with SSL
Date: 2014-12-15 18:17:53
Message-ID: 13394.1418667473@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kido Kouassi 2014-12-15 18:23:56 Re: Yum Install postgresql93 with SSL
Previous Message John Scalia 2014-12-15 18:10:47 Re: Yum Install postgresql93 with SSL