Date: Tue, 27 Jul 2021 13:57:09 +0700
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?
Message-ID: <YP+uRTHka6GOLU0x@admin.sibptus.ru>
References: <YP6QJja3b+2nZ3z7@admin.sibptus.ru>
 <353A1D55-3DFF-43B1-B906-147C9C511435@elevated-dev.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="tkyKw53ahib+5+vx"
Content-Disposition: inline
In-Reply-To: <353A1D55-3DFF-43B1-B906-147C9C511435@elevated-dev.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YP%2BuRTHka6GOLU0x%40admin.sibptus.ru>
Precedence: bulk


--tkyKw53ahib+5+vx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Scott Ribe wrote:
> > Is anyone running PostgreSQL in Kubernetes? If you do, what solution do
> > you prefer?=20
> >=20
> > What I've tried myself:
> >=20
> > 1. Running the official postgres:12.6 images in a StatefulSet. It works
> > fine but there is neither failover nor replication.
> >=20
> > 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.
> >=20
> > I'd be especially grateful if you shared your own personal experience
> > with Kubernetes and PostgreSQL.
>=20
> We're using CrunchyData's operator, which in turn uses Patroni & pgbackre=
st...

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?

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

--tkyKw53ahib+5+vx
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQEcBAEBAgAGBQJg/65FAAoJEA2k8lmbXsY0VsAH/Au4+oRZrC0Wq27/3KJmUpOj
FQkogSzgjuMeObEb1IYXI9ChsA5fAINbNfoQaWAUT6d6ktZ2huFIkPSveEZwkfmn
6AOrkb09hkugAPk6A+I3dGLa0iAH1hGqHFblE8T/9CrZTuw7ttd7UnXTbjaHjp4j
DelX+vRU3NlCZDZ/E9NyG5f1sJZza5I1rNXnRYGT4SxlQ7EvBJetjXQFLRqgxdPl
kocG6+XKhsVzIM7Y5h5AbOB5Umt5J4fzxtKgn1V0DKJDOpnZY6v1iH3n7x8lzX2j
cODrEK2SytJlEKarwGYbnffGynNwSBTay/qCYVqhx276azHEqwcqvIhLwgjuFPg=
=H3Vu
-----END PGP SIGNATURE-----

--tkyKw53ahib+5+vx--