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
_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
