Greetings, * Paul Förster (paul.foerster@xxxxxxxxx) wrote: > > On 13. Jul, 2020, at 18:00, Stephen Frost <sfrost@xxxxxxxxxxx> wrote: > > Ah, yes, if you rebuild the replica from a backup (or from the primary), > > then sure, that's pretty similar to the pgbackrest delta restore, except > > that when using delta restore we're only rewriting files that have a > > different SHA checksum after being scanned, and we're pulling from the > > backup repo anything that's needed and not putting load on the primary. > > so, from what I understand, pgbackrest bottom line merely reduces copy overhead in such a particular case. *Kind of* like shutdown primary, rsync, and then startup. Yes, though unlike rsync, pgbackrest can also run in parallel.. :) > > There's been a few discussions on -hackers about this, that'd probably > > be the place to discuss it further.. > > I'm not hacker, I'm just a DBA. :-) You're a PG user, so your input is (at least) as valuable regarding things like this, imv. :) Thanks! Stephen
Attachment:
signature.asc
Description: PGP signature