Re: Running PostgreSQL in Kubernetes?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Victor Sudakov <vas(at)sibptus(dot)ru>
Cc: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Running PostgreSQL in Kubernetes?
Date: 2021-07-28 20:34:51
Message-ID: 20210728203451.GC20766@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

* Victor Sudakov (vas(at)sibptus(dot)ru) wrote:
> Scott Ribe wrote:
> > > On Jul 27, 2021, at 12:57 AM, Victor Sudakov <vas(at)sibptus(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2021-07-29 05:18:08 Re: Running PostgreSQL in Kubernetes?
Previous Message Kevin Struckhoff 2021-07-27 19:27:25 Re: Installing pgAdmin-web on CentOS 8 not working