Search Postgresql Archives

Re: Safe switchover

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux