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 13:57:09 +0700
Message-ID: <YP+uRTHka6GOLU0x@admin.sibptus.ru> (raw)
In-Reply-To: <353A1D55-3DFF-43B1-B906-147C9C511435@elevated-dev.com>
References: <YP6QJja3b+2nZ3z7@admin.sibptus.ru>
<353A1D55-3DFF-43B1-B906-147C9C511435@elevated-dev.com>
Scott Ribe wrote:
> > Is anyone running PostgreSQL in Kubernetes? If you do, what solution do
> > you prefer?
> >
> > What I've tried myself:
> >
> > 1. Running the official postgres:12.6 images in a StatefulSet. It works
> > fine but there is neither failover nor replication.
> >
> > 2. Zalando's postgres-operator. Replication and failover work out of the
> > box, but the documentation is not the best. Things like wal-g backup and
> > PITR are probably possible, but you need to be an egghead to figure out
> > how to make them work. Why, I cannot even figure out how to add a
> > team after installing the postgres-operator from the official Helm repo.
> >
> > I'd be especially grateful if you shared your own personal experience
> > with Kubernetes and PostgreSQL.
>
> We're using CrunchyData's operator, which in turn uses Patroni & pgbackrest...
Hello Scott,
Thank you for the hint! The CrunchyData's operator looks like a cleaner
implementation than Zalando's. I'll continue testing.
Have you been able to a) upload backups to S3 and b) perform PITR from
S3 with CrunchyData?
--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet
Attachments:
signature.asc (application/pgp-signature, 454B) download
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: <YP+uRTHka6GOLU0x@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