libpq.dll for win32 always using ssl

I've compiled libpq.dll for Windows including the OpenSSL functionaility. It works great, but I can't seem to turn off SSL encryption.

From what I undertand, the libpq function PQconnectdb should be able to take the option "requiressl=1". I was thinking that stating "requiressl=0" might turn off SSL; or, perhaps simply not specifying the requiressl option might turn off SSL. Neither of these seem to be the case. Can anyone help? How can I force the library not to use encryption?

Thanks.
-Tony

p.s. For what it's worth, I'm getting about a 30% speed hit with using SSL in my database queries.

"Tony and Bryn Reina" <reina_ga(at)hotmail(dot)com> writes:
> ? How can I force the library not to use encryption?

In 7.3 you can't. 7.4 changed the meaning of the option so that you
can.

regards, tom lane

Ahhh! My bad. I see now from the 7.4 docs that a new option called 'sslmode'
is defined and 'requiressl' is deprecated. This seems to work nicely.

Thanks Tom.
-Tony

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tony and Bryn Reina" <reina_ga(at)hotmail(dot)com>
Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
Sent: Tuesday, December 16, 2003 3:23 PM
Subject: Re: [pgsql-hackers-win32] libpq.dll for win32 always using ssl

> "Tony and Bryn Reina" <reina_ga(at)hotmail(dot)com> writes:
> > ? How can I force the library not to use encryption?
>
> In 7.3 you can't. 7.4 changed the meaning of the option so that you
> can.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

Tony and Bryn Reina wrote:
> Ahhh! My bad. I see now from the 7.4 docs that a new option called 'sslmode'
> is defined and 'requiressl' is deprecated. This seems to work nicely.

Also, I don't think you will see the 30% degredation for SSL you saw in
7.3.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073