Re: SSL confirmation - Mailing list pgsql-general

From Andrew M
Subject Re: SSL confirmation
Date
Msg-id 48FFB86A-46F9-11D9-8BA6-0003938366A4@jibeya.com
Whole thread Raw
In response to Re: SSL confirmation  (Michael Fuhr <mike@fuhr.org>)
Responses Re: SSL confirmation  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael,
are you saying I need to do:

'select * from myTable where x=y sslmode=require'

to make a request to the database a secure one? If so, as I am using
Hibernate, do you know how I would alter my maps to reflect this?

regards

Andrew
On 5 Dec 2004, at 19:41, Michael Fuhr wrote:

> On Sun, Dec 05, 2004 at 12:27:33PM -0700, Michael Fuhr wrote:
>
>> On the client side you could set the PGSSLMODE environment variable
>> to "require" (or the older PGREQUIRESSL to "1"), which should tell
>> libpq to attempt only SSL connections.
>
> I forgot to mention that you could also use "sslmode=require" or
> "requiressl=1" (deprecated in 7.4 and later) in your connect string
> if you're using libpq directly or your interface to libpq allows it.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: SSL confirmation
Next
From: Michael Fuhr
Date:
Subject: Re: SSL confirmation