pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Stephen Frost <sfrost@snowman.net>
To: Victor Sudakov <vas@sibptus.ru>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Running PostgreSQL in Kubernetes?
Date: Wed, 28 Jul 2021 16:34:51 -0400
Message-ID: <20210728203451.GC20766@tamriel.snowman.net> (raw)
In-Reply-To: <YQA3JudCthBjJ9nV@admin.sibptus.ru>
References: <YP6QJja3b+2nZ3z7@admin.sibptus.ru>
	<353A1D55-3DFF-43B1-B906-147C9C511435@elevated-dev.com>
	<YP+uRTHka6GOLU0x@admin.sibptus.ru>
	<2B89961F-4400-4523-9CCA-A2A9000E713C@elevated-dev.com>
	<YQA3JudCthBjJ9nV@admin.sibptus.ru>

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

Attachments:

  signature.asc (application/pgp-signature, 818B) download

view thread (12+ messages)  latest in thread

Message-ID: <20210728203451.GC20766@tamriel.snowman.net>
Permalink:  ../20210728203451.GC20766@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20210728203451.GC20766@tamriel.snowman.net

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sfrost@snowman.net, vas@sibptus.ru, scott_ribe@elevated-dev.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Running PostgreSQL in Kubernetes?
  In-Reply-To: <20210728203451.GC20766@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox