Re: PQConnectdb SSL (sslmode): Is this a bug

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: vishal saberwal <vishalsaberwal(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: PQConnectdb SSL (sslmode): Is this a bug
Date: 2005-08-26 22:36:19
Message-ID: 20050826223619.GB19045@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 26, 2005 at 02:03:05PM -0700, vishal saberwal wrote:
> sorry, but forgot to mention,
> when i change to sslmode=allow, it lets me connect and runs my query

That's because "allow" attempts a non-SSL connection first, whereas
"prefer" attempts an SSL connection first. If the server permits
non-SSL connections then "allow" will get you connected as non-SSL
without ever attempting SSL.

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2005-08-26 22:50:43 Re: Postgresql replication
Previous Message Michael Fuhr 2005-08-26 22:33:36 Re: PQConnectdb SSL (sslmode): Is this a bug