From: tushar <tushar.ahuja@enterprisedb.com>
To: Robert Haas <robertmhaas@gmail.com>
To: Mark Dilger <mark.dilger@enterprisedb.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: refactoring basebackup.c
Date: Mon, 19 Jul 2021 16:34:27 +0530
Message-ID: <d75392ef-67b0-c41f-add0-6d52867ee568@enterprisedb.com> (raw)
In-Reply-To: <CA+TgmoYgVN=-Yoh71r3P9N7eKysd7_9b9s+1QFfFcs3w7Z-tig@mail.gmail.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tushar.ahuja@enterprisedb.com, robertmhaas@gmail.com, mark.dilger@enterprisedb.com
Subject: Re: refactoring basebackup.c
In-Reply-To: <d75392ef-67b0-c41f-add0-6d52867ee568@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox