Обсуждение: Connection Options -- SSL already uses compression?

Am I reading this correctly -- it appears that if SSL negotiation is enabled for a connection (say, when using pg_basebackup over a WAN) that compression is automatically used (provided it is supported on both ends)?

Is there a way to check and see if it is on for a given connection?

I was looking to hack in zlib support and saw that appears to be already-present support, provided SSL connection security is enabled.

On Sat, Oct 20, 2012 at 3:10 AM, Karl Denninger <karl@denninger.net> wrote:
> Am I reading this correctly -- it appears that if SSL negotiation is enabled
> for a connection (say, when using pg_basebackup over a WAN) that compression
> is automatically used (provided it is supported on both ends)?

That would depend on the OpenSSL defaults, I believe. Pretty sure you
can configure that system wide.


> Is there a way to check and see if it is on for a given connection?

You can use PQgetssl() and then use OpenSSL functions to get the info
from there. I'm not sure exactly how, but it would surprise me if it's
not possible.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/