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... -- JayOn 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 install1- 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 startat 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 start2- Nothing was logged in the log file.Thank you in advance for your help,--Kido K
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 install1- 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 startat 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 start2- Nothing was logged in the log file.Thank you in advance for your help,--Kido K
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных