Euler Taveira wrote: > There was already some discussion about compressing libpq data [1][2][3]. > Recently, I faced a scenario that would become less problematic if we have had > compression support. The scenario is frequent data load (aka COPY) over > slow/unstable links. It should be executed in a few hundreds of PostgreSQL > servers all over Brazil. Someone could argue that I could use ssh tunnel to > solve the problem but (i) it is complex because it involves a different port > in the firewall and (ii) it's an opportunity to improve other scenarios like > reducing bandwidth consumption during replication or normal operation over > slow/unstable links.
Maybe I'm missing something obvious, but shouldn't a regular SSL connection (sslmode=require) do what you are asking for? At least from OpenSSL 0.9.8 on, data get compressed by default. You don't need an extra port in the firewall for that. Yours, Laurenz Albe -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers