Re: refactoring basebackup.c

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(at)centos7tushar bin]$ du -sch data/
578M    data/
578M    total

-h=localhost

[edb(at)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(at)centos7tushar bin]$ du -sch /tmp/all_data2
322M    /tmp/all_data2
322M    total
[edb(at)centos7tushar bin]$

-h=remote

[edb(at)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(at)0 bin]$ du -sch /tmp/all_data2
167M    /tmp/all_data2
167M    total
[edb(at)0 bin]$

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