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=jdbcostgresql://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.
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.