sslmode=prefer v.s. sslmode=verify-ca

From: Bastiaan Olij <bastiaan(at)basenlily(dot)me>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: sslmode=prefer v.s. sslmode=verify-ca
Date: 2014-02-27 01:25:55
Message-ID: 530E9423.5070206@basenlily.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message itishree sukla 2014-02-27 06:24:39 Multiple Schema in One DB
Previous Message Steve Crawford 2014-02-27 00:44:56 Re: Cancelling of autovacuums considered harmful