| 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: | Whole Thread | Raw Message | 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 |