Re: Force ssl connection - Mailing list pgsql-general

From Muhammad Bashir Al-Noimi
Subject Re: Force ssl connection
Date
Msg-id CABpATRsOYbZb+0FBfiW=pizG92gi+u1JAP4KJ6LzxgHqTFffyw@mail.gmail.com
Whole thread Raw
In response to Re: Force ssl connection  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Force ssl connection  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
On Wed, Jul 10, 2013 at 12:16 PM, Magnus Hagander <magnus@hagander.net> wrote:
> requiressl=0 doesn't mean what you think it means, and that's one
> reason it has been deprecated since at least 8.2.
>
> requiressl=0 means "negotiate. use ssl if the server asks for it, but
> accept not using ssl". So this will connect without an error both with
> and without ssl.
>
> If you want to enforce ssl, use sslmode=require.
> If you want to enforce non-ssl, use sslmode=disable.


This is exactly what I'm looking for... thanks a lot it works perfectly.

--
Best Regards
Muhammad Bashir Al-Noimi


pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Force ssl connection
Next
From: Kevin Grittner
Date:
Subject: Re: Computing count of intersection of two queries (Relational Algebra --> SQL)