[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] pg_basebackup running from a remote machine
From:       Jeff Janes <jeff.janes () gmail ! com>
Date:       2017-11-16 6:47:27
Message-ID: CAMkU=1xcQjg_XWZvk7-0nSUEXakBPdqfoh97ogNeLp0kVc9-GQ () mail ! gmail ! com
[Download RAW message or body]

On Tue, Nov 14, 2017 at 8:28 AM, Laurenz Albe <laurenz.albe@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

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Tue, Nov 14, 2017 \
at 8:28 AM, Laurenz Albe <span dir="ltr">&lt;<a \
href="mailto:laurenz.albe@cybertec.at" \
target="_blank">laurenz.albe@cybertec.at</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><span class="">rakeshkumar464 wrote:<br> &gt; If \
pg_basebackup is run from a remote machine with compress option --gzip ,<br> &gt; \
compress level 9,<br> &gt; will the compression occur prior to the data being sent on \
the network or<br> &gt; after it has been received<br>
&gt; at the remote machine.<br>
<br>
</span>That only means that the output TAR file will be compressed, it has<br>
nothing to do with the data transfered from the server.<br>
<br>
If you want to compress the data sent over the network, use<br>
pg_basebackup over an SSL connection with SSL compression \
enabled.<br></blockquote><div><br></div><div>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.</div><div><br></div><div>Cheers,</div><div><br></div><div>Jeff</div></div></div></div>




[prev in list] [next in list] [prev in thread] [next in thread]