From: | Andrew M <andrew(at)jibeya(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SSL confirmation |
Date: | 2004-12-05 20:07:26 |
Message-ID: | 48FFB86A-46F9-11D9-8BA6-0003938366A4@jibeya.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2004-12-05 20:39:11 | Re: Index bloat in 7.2 |
Previous Message | Rodrigo Carvalhaes | 2004-12-05 19:43:36 | Re: pg_restore taking 4 hours! |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2004-12-05 20:39:12 | Re: SSL confirmation |
Previous Message | Larry White | 2004-12-05 20:04:57 | Re: prepared statement call fails |