[Qgis-developer] Compression in libpq?

[Jean-Roc Morreale]

The connections are made through KiTTY which create a ssh tunnel, all 
the applications then connect to the distant postgresql server like a 
local one with the bonus of encryption, compression and no application 
specific setup (even if I would love having an unblocked 5432 port).

Le 2015-02-13 10:35, Andreas Neumann a écrit :
> Hi Jean-Roc,
> 
> Thanks about this hint. I am vaguely aware about this option with pg
> connections through ssh with gzip. But I did not try it. Do you have
> any pointers how to set this up?
> 
> Anyway - having this built in to our existing software without having
> to set up ssh connections would be a big plus.
> 
> Thanks,
> Andreas
> 
> On 13.02.2015 10:31, Jean-Roc Morreale wrote:
>> Andreas, did you you try to setup these connection over ssh ? ssh -C 
>> uses gzip
>> 
>> Le 2015-02-13 10:26, Andreas Neumann a écrit :
>>> Hi,
>>> 
>>> Just came across this:
>>> 
>>> http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-pglz-compression-libpqcommon/ 
>>> This read is very technical.
>>> 
>>> Question: does this mean that a future libpq will support 
>>> compression?
>>> I think this would be very interesting for us, esp. if you work with
>>> PostgreSQL connections through slower network connections. I always
>>> found remote Postgis connections that are not on the same LAN quite
>>> slow.
>>> 
>>> Any comments?
>>> 
>>> Andreas