Обсуждение: 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@hotmail.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@sss.pgh.pa.us> To: "Tony and Bryn Reina" <reina_ga@hotmail.com> Cc: <pgsql-hackers-win32@postgresql.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@hotmail.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@postgresql.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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073