From: John Scalia <jayknowsunix@gmail.com>
To: Kido Kouassi <jjkido@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Yum Install postgresql93 with SSL
Date: Mon, 15 Dec 2014 13:10:47 -0500
Message-ID: <548F2427.2060102@gmail.com> (raw)
In-Reply-To: <CA+ebzumSN0UG+JhWvGjuqC2a8RDf84yew8z8cqg=P7GWLTFXvw@mail.gmail.com>
References: <CA+ebzumSN0UG+JhWvGjuqC2a8RDf84yew8z8cqg=P7GWLTFXvw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jayknowsunix@gmail.com, jjkido@gmail.com
Subject: Re: Yum Install postgresql93 with SSL
In-Reply-To: <548F2427.2060102@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox