Subject: Re: refactoring basebackup.c
To: Robert Haas <robertmhaas@gmail.com>,
 Mark Dilger <mark.dilger@enterprisedb.com>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
References: 
 <CA+TgmoZGwR=ZVWFeecncubEyPdwghnvfkkdBe9BLccLSiqdf9Q@mail.gmail.com>
 <CA+TgmoZBqs7KkyBUFzXQaztuonKanuOV+f_7DYsHOpJs=0B2DA@mail.gmail.com>
 <CA+TgmoY5zpS=gJj2O0PXi6YGao5YR89v0qN_xZzWNvff2Tug+Q@mail.gmail.com>
 <58D2BD01-B541-4032-9C0B-B6143841E7ED@enterprisedb.com>
 <CA+TgmoYgVN=-Yoh71r3P9N7eKysd7_9b9s+1QFfFcs3w7Z-tig@mail.gmail.com>
From: tushar <tushar.ahuja@enterprisedb.com>
Message-ID: <d75392ef-67b0-c41f-add0-6d52867ee568@enterprisedb.com>
Date: Mon, 19 Jul 2021 16:34:27 +0530
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.9.0
MIME-Version: 1.0
In-Reply-To: 
 <CA+TgmoYgVN=-Yoh71r3P9N7eKysd7_9b9s+1QFfFcs3w7Z-tig@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------5FB2406A6882A40A4387C58E"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/d75392ef-67b0-c41f-add0-6d52867ee568%40enterprisedb.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------5FB2406A6882A40A4387C58E
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

On 7/8/21 9:26 PM, Robert Haas wrote:
> Here at last is a new version.
if i try to perform pg_basebackup using "-t server " option against 
localhost V/S remote machine ,
i can see difference in backup size.

data directory whose size is

[edb@centos7tushar bin]$ du -sch data/
578M    data/
578M    total

-h=localhost

[edb@centos7tushar bin]$ ./pg_basebackup -t server:/tmp/all_data2*-h 
localhost*   -Xnone --no-manifest -P -v
pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
NOTICE:  all required WAL segments have been archived
329595/329595 kB (100%), 1/1 tablespace
pg_basebackup: base backup completed

[edb@centos7tushar bin]$ du -sch /tmp/all_data2
322M    /tmp/all_data2
322M    total
[edb@centos7tushar bin]$

-h=remote

[edb@centos7tushar bin]$ ./pg_basebackup -t server:/tmp/all_data2 *-h 
<remote IP>* -Xnone --no-manifest -P -v
pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
NOTICE:  all required WAL segments have been archived
170437/170437 kB (100%), 1/1 tablespace
pg_basebackup: base backup completed

[edb@0 bin]$ du -sch /tmp/all_data2
167M    /tmp/all_data2
167M    total
[edb@0 bin]$

-- 
regards,tushar
EnterpriseDB  https://www.enterprisedb.com/
The Enterprise PostgreSQL Company


--------------5FB2406A6882A40A4387C58E
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">On 7/8/21 9:26 PM, Robert Haas wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+TgmoYgVN=-Yoh71r3P9N7eKysd7_9b9s+1QFfFcs3w7Z-tig@mail.gmail.com">
      <pre class="moz-quote-pre" wrap="">Here at last is a new version.</pre>
    </blockquote>
    if i try to perform pg_basebackup using "-t server " option against
    localhost V/S remote machine ,<br>
    i can see difference in backup size.<br>
    <p>data directory whose size is <br>
    </p>
    <p>[edb@centos7tushar bin]$ du -sch data/<br>
      578M    data/<br>
      578M    total<br>
    </p>
    <p>-h=localhost <br>
    </p>
    <p>[edb@centos7tushar bin]$ ./pg_basebackup -t server:/tmp/all_data2<b>
        -h localhost</b>   -Xnone --no-manifest -P -v<br>
      pg_basebackup: initiating base backup, waiting for checkpoint to
      complete<br>
      pg_basebackup: checkpoint completed<br>
      NOTICE:  all required WAL segments have been
      archived                           <br>
      329595/329595 kB (100%), 1/1
      tablespace                                         <br>
      pg_basebackup: base backup completed<br>
    </p>
    <p>[edb@centos7tushar bin]$ du -sch /tmp/all_data2<br>
      322M    /tmp/all_data2<br>
      322M    total<br>
      [edb@centos7tushar bin]$ <br>
    </p>
    <p>-h=remote <br>
    </p>
    <p>[edb@centos7tushar bin]$ ./pg_basebackup -t server:/tmp/all_data2
      <b>-h &lt;remote IP&gt;</b> -Xnone --no-manifest -P -v<br>
      pg_basebackup: initiating base backup, waiting for checkpoint to
      complete<br>
      pg_basebackup: checkpoint completed<br>
      NOTICE:  all required WAL segments have been
      archived                           <br>
      170437/170437 kB (100%), 1/1
      tablespace                                         <br>
      pg_basebackup: base backup completed<br>
    </p>
    <p>[edb@0 bin]$ du -sch /tmp/all_data2<br>
      167M    /tmp/all_data2<br>
      167M    total<br>
      [edb@0 bin]$ <br>
    </p>
    <pre class="moz-signature" cols="72">-- 
regards,tushar
EnterpriseDB  <a class="moz-txt-link-freetext" href="https://www.enterprisedb.com/">https://www.enterprisedb.com/</a>
The Enterprise PostgreSQL Company
</pre>
  </body>
</html>

--------------5FB2406A6882A40A4387C58E--