cancel
Showing results for 
Search instead for 
Did you mean: 

Postgres SSL/TLS

ratkiewi
Champ in-the-making
Champ in-the-making
Good day,

I am trying to setup a TLS/SSL connection between my Alfresco box and Postgres Database server.  I have not seen any documentation on this, and am not sure if it is even supported.  My database config works fine without encryption, but if I configure my Postgres conf file to require SSL and modify the jdbc string to:  db.url=jdbcSmiley Tongueostgresql://server:5432/alfresco?ssl=true per some jdbc docs, but it still doesn't seem to function.  Any pointers/guidance would be very much appreciated.
1 REPLY 1

ratkiewi
Champ in-the-making
Champ in-the-making
I found the issue.  The jdbc string is correct, but I had an expired certificate on the pgsql server.  After I updated the certificate on pgsql, I also had to import the intermediate cert with the java keystore util.  Verified OTW encryption is working with tcpdump.