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
