Greetings,
* Victor Sudakov (vas@sibptus.ru) wrote:
> Scott Ribe wrote:
> > > On Jul 27, 2021, at 12:57 AM, Victor Sudakov <vas@sibptus.ru> wrote:
> > >
> > > Have you been able to a) upload backups to S3 and b) perform PITR from
> > > S3 with CrunchyData?
> >
> > I have never tried either.
> >
> > I have recovered from the backups,
>
> Using the CrunchyData operator built-in backup service?
>
> > but never used PITR from the WAL archives.
>
> It's really very efficient and elegant with wal-g. wal-g fetches data
> from S3 in parallel and can prefetch.
>
> I've done PITR from S3 many times in a lab, and a couple of times on
> real data. But to use wal-g inside Kubernetes, I probably need
> Zalando's operator which I dislike.
The Crunchy operator uses pgbackrest, which also supports parallel
restore and pre-fetching.
Thanks,
Stephen