Re: [(catch-ext)] Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time

2022-08-18 Thread Ivan N. Ivanov
ance in Germany and the speed in copying is around 50 MB/sec max, that >> is why it takes 2 days for copying. >> >> I will try using high compression for the basebackup to reduce the time. >> >> pgbackrest is an alternative, too >> >> Thank you again! >

Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time

2022-08-18 Thread Ivan N. Ivanov
for copying. I will try using high compression for the basebackup to reduce the time. pgbackrest is an alternative, too Thank you again! On Wed, Aug 17, 2022 at 11:13 PM Ivan N. Ivanov wrote: > Thank you for your answer! I have found this tool and I will try it > tomorrow to see i

Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time

2022-08-17 Thread Ivan N. Ivanov
Thank you for your answer! I have found this tool and I will try it tomorrow to see if this "read-ahead" feature will speed up the process. On Wed, Aug 17, 2022 at 11:09 PM Christophe Pettus wrote: > > > > On Aug 17, 2022, at 13:06, Ivan N. Ivanov > wrote: > > &g

Setting up streaming replication on large database (20+ TB) for the first time

2022-08-17 Thread Ivan N. Ivanov
I have a large database (~25 TB) and I want to set up streaming replication for the first time. My problem is that after completion of the pg_basebackup (which completed for 2 days with --wal-method=none) now PG is replaying the WAL files from the WAL archive directory but it can not keep up. The