compression of query and result data in tcp socket connections

From: Oguz Yilmaz <oguzyilmazlist(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: compression of query and result data in tcp socket connections
Date: 2011-09-05 11:23:12
Message-ID: CAAo+KFmcJzcgX4rEnv7Y1fYFG4Zyo5A8AnhLwRdPoGVR9ehTaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We need some handy method for compression of pgsql communication on
port 5432. For my case, database is available over the internet and
application logic has to reach the database remotely.

I have searched for it and found those threads:
http://archives.postgresql.org/pgsql-hackers/2002-05/msg00752.php
http://archives.postgresql.org/pgsql-general/2010-08/msg00003.php
http://archives.postgresql.org/pgsql-hackers/2002-03/msg00664.php
http://archives.postgresql.org/pgsql-hackers/2006-05/msg01318.php

Some suggested ssh tunneling for the compression as a wrapper. However
this requires having to open ssh tunnels seperately for each remote db
server. So this is not much handy for us.

Is it possible to include compression on tcp db connection through a
way which is more internal to postgresql.

Best Regards,

--
Oguz YILMAZ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Radosław Smogura 2011-09-05 11:28:33 Re: compression of query and result data in tcp socket connections
Previous Message Radosław Smogura 2011-09-05 11:05:28 Protocol question - fastpath & parameter status 'S'