pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Connection Options -- SSL already uses compression?
2+ messages / 2 participants
[nested] [flat]

* Connection Options -- SSL already uses compression?
@ 2012-10-20 01:10  Karl Denninger <karl@denninger.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Karl Denninger @ 2012-10-20 01:10 UTC (permalink / raw)
  To: pgsql-performance

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.

-- 
-- Karl Denninger
/The Market Ticker ®/ <http://market-ticker.org;
Cuda Systems LLC

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Connection Options -- SSL already uses compression?
@ 2012-10-21 07:51  Magnus Hagander <magnus@hagander.net>
  parent: Karl Denninger <karl@denninger.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Magnus Hagander @ 2012-10-21 07:51 UTC (permalink / raw)
  To: Karl Denninger <karl@denninger.net>; +Cc: pgsql-performance

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/




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2012-10-21 07:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-20 01:10 Connection Options -- SSL already uses compression? Karl Denninger <karl@denninger.net>
2012-10-21 07:51 ` Magnus Hagander <magnus@hagander.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox