Hello,
I have no problem connecting without SSL to my postgresql server utilizing an ssh tunnel, but if I try to enable SSL
forthe postgresql db connection with verify-ca it doesn't work. I'm supplying the root certificate, but we don't use
clientcertificates for authentication, only username/password. I'm able to get this same setup working in sqlworkbench,
butfor some reason, I'm not able to use SSL for the DB connection using verify-ca supplying only the root.crt. Do I
needto be using client certificate authentication for SSL to work for the db connection.
Daryl Roche
Systems Administrator, Research IM.IT
BC Children's Hospital Research Institute
University of British Columbia
604-875-2345 x4648 | droche@bcchr.ubc.ca