Hi All, According to the documentation here:http://www.postgresql.org/docs/9.1/static/libpq-ssl.html For backwards compatibility reasons sslmode=require works the same as sslmode=verify-ca if a root certificate is put into place. >From what I can tell sslmode=prefer seems to react the same. As I have both servers with valid certificates, and one or two test servers with just self signed certificates I'm running into a snag. As soon as I put my root certificate in place I can log onto the servers with valid certificates just fine, I'm using sslmode=verify-full here even. But when I try to connect to my test servers, even though I've set sslmode=prefer, it won't allow me to connect over SSL. Only when I remove my root certificate file am I allowed in. Obviously I can create valid certificates for my test servers but some of the servers I need to connect to aren't fully under my control. Has anyone run into this before? Cheers, Bastiaan Olij -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
