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
