I have a remote Redhat Postgresql box running SSL-enabled. I can successfully connect securely via my desktop in pgAdmin3 at least. I'm using keytool to install the certificate(s) in different combinations but am unsuccessful.
E:\JRun4\jre\bin>keytool -importcert -alias postgresql -file C:\dcacerts\postgresql.crt -keystore E:\Jrun4\jre\lib\security\cacerts -trustcacerts
E:\JRun4\jre\bin>keytool -importcert -alias postgresql2 -file C:\dcacerts\root.crt -keystore E:\Jrun4\jre\lib\security\cacerts -trustcacerts
I also converted these CRTs to CERs for der format, and no luck either.
E:\JRun4\jre\bin>keytool -importcert -alias postgresql -file C:\dcacerts\postgresql.cer -keystore E:\Jrun4\jre\lib\security\cacerts -trustcacerts
E:\JRun4\jre\bin>keytool -importcert -alias postgresql2 -file C:\dcacerts\root.cer -keystore E:\Jrun4\jre\lib\security\cacerts -trustcacerts
The client box is Windows 2003 with ColdFusion 8 Enterprise.