Yum Install postgresql93 with SSL

From: Kido Kouassi <jjkido(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Yum Install postgresql93 with SSL
Date: 2014-12-15 17:58:24
Message-ID: CA+ebzumSN0UG+JhWvGjuqC2a8RDf84yew8z8cqg=P7GWLTFXvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2014-12-15 18:10:47 Re: Yum Install postgresql93 with SSL
Previous Message Matthieu Lejeune 2014-12-15 11:02:22 Re: Problem pg_upgradecluster from 9.1 to 9.3