On Tue, Nov 14, 2017 at 8:28 AM, Laurenz Albe <laurenz.a...@cybertec.at> wrote:
> rakeshkumar464 wrote: > > If pg_basebackup is run from a remote machine with compress option > --gzip , > > compress level 9, > > will the compression occur prior to the data being sent on the network or > > after it has been received > > at the remote machine. > > That only means that the output TAR file will be compressed, it has > nothing to do with the data transfered from the server. > > If you want to compress the data sent over the network, use > pg_basebackup over an SSL connection with SSL compression enabled. > But ssl compression is disabled by default on most systems, and not even supported at all on many without doing a custom compilation of the ssl library. Cheers, Jeff