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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Vincent Picavet - Gérant Oslandia www.oslandia.com _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
