pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Victor Sudakov <vas@sibptus.ru>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Running PostgreSQL in Kubernetes?
Date: Tue, 27 Jul 2021 23:41:10 +0700
Message-ID: <YQA3JudCthBjJ9nV@admin.sibptus.ru> (raw)
In-Reply-To: <2B89961F-4400-4523-9CCA-A2A9000E713C@elevated-dev.com>
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>

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.

-- 
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet

Attachments:

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

view thread (12+ messages)  latest in thread

Message-ID: <YQA3JudCthBjJ9nV@admin.sibptus.ru>
Permalink:  ../YQA3JudCthBjJ9nV@admin.sibptus.ru/
Also on:    postgresql.org/message-id/YQA3JudCthBjJ9nV@admin.sibptus.ru

 · 

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: vas@sibptus.ru, scott_ribe@elevated-dev.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Running PostgreSQL in Kubernetes?
  In-Reply-To: <YQA3JudCthBjJ9nV@admin.sibptus.ru>

* 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