[Qgis-developer] Compression in libpq?

[Vincent Picavet - ML]

Hi,

Another option is to use SSL, which since version 0.9.8 uses compression by 
default. In this case you do not need any specific software neither tunnels.

SSH tunnels are a good solution too though. 
Setting up a VPN with compression activated is another option.

Just be aware that compressing compressed data is useless, so better choose a 
single option and stick to it.

Vincent

Le vendredi 13 février 2015, 11:18:23 Jean-Roc Morreale a écrit :
> 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-pg
> >>> lz-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
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
Vincent Picavet - Gérant Oslandia
www.oslandia.com