Re: Running PostgreSQL in Kubernetes? - Mailing list pgsql-admin

From Stephen Frost
Subject Re: Running PostgreSQL in Kubernetes?
Date
Msg-id 20210728203451.GC20766@tamriel.snowman.net
Whole thread Raw
In response to Re: Running PostgreSQL in Kubernetes?  (Victor Sudakov <vas@sibptus.ru>)
List pgsql-admin
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

Attachment

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Running PostgreSQL in Kubernetes?
Next
From: Vijaykumar Jain
Date:
Subject: Re: Running PostgreSQL in Kubernetes?