Re: [GENERAL] Replication: GZIP compression in WAL sender/receiver processes communication?

2013-12-30 Thread Sergey Konoplev
On Mon, Dec 9, 2013 at 3:13 PM, Dmitry Koterov dmi...@koterov.ru wrote: Is there a way to compress the traffic between master and slave during the replication?.. The streaming gzip would be quite efficient for that. Take a look at the ssh_tunnel.sh [1] tool. This is a wrapper around SSH tunnel

Re: [GENERAL] Replication: GZIP compression in WAL sender/receiver processes communication?

2013-12-18 Thread Rahila Syed
Hello, Yes gzip compression can be used for compressing WAL traffic during streaming replication Following tools can be used in this regard. SSL compression-SSL support is built in PostgreSQL. You need to ensure you have OpenSSL library support in your PostgreSQL installation. Also, you can

Re: [GENERAL] Replication: GZIP compression in WAL sender/receiver processes communication?

2013-12-17 Thread Rahila Syed
Hello, Yes, gzip compression can be used for compressing WAL traffic during streaming replication Following tools can be used in this regard. SSL compression-SSL support is built in PostgreSQL. You need to ensure you have OpenSSL library support in your PostgreSQL installation. Also, you can

[GENERAL] Replication: GZIP compression in WAL sender/receiver processes communication?

2013-12-09 Thread Dmitry Koterov
Hello. Is there a way to compress the traffic between master and slave during the replication?.. The streaming gzip would be quite efficient for that. (WAL archiving is not too good for this purpose because of high lag. I just need to minimize the cross-datacenter traffic keeping the replication

Re: [GENERAL] Replication: GZIP compression in WAL sender/receiver processes communication?

2013-12-09 Thread Michael Paquier
On Tue, Dec 10, 2013 at 8:13 AM, Dmitry Koterov dmi...@koterov.ru wrote: Hello. Is there a way to compress the traffic between master and slave during the replication?.. The streaming gzip would be quite efficient for that. (WAL archiving is not too good for this purpose because of high lag.

Re: [GENERAL] Replication: GZIP compression in WAL sender/receiver processes communication?

2013-12-09 Thread John R Pierce
On 12/9/2013 3:13 PM, Dmitry Koterov wrote: Is there a way to compress the traffic between master and slave during the replication?.. The streaming gzip would be quite efficient for that. (WAL archiving is not too good for this purpose because of high lag. I just need to minimize the