Date: Mon, 26 Jul 2021 17:36:22 +0700
From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: Running PostgreSQL in Kubernetes?
Message-ID: <YP6QJja3b+2nZ3z7@admin.sibptus.ru>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="hWpEmYwtOzEddg2F"
Content-Disposition: inline
Archived-At: 
 <https://www.postgresql.org/message-id/YP6QJja3b%2B2nZ3z7%40admin.sibptus.ru>
Precedence: bulk


--hWpEmYwtOzEddg2F
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Dear Colleagues,

Is anyone running PostgreSQL in Kubernetes? If you do, what solution do
you prefer?=20

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.

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

--hWpEmYwtOzEddg2F
Content-Type: application/pgp-signature; name="signature.asc"

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

iQEcBAEBAgAGBQJg/pAmAAoJEA2k8lmbXsY0Hd8IAIhLjjdVCRP42UomyInm+HmO
bgnJj+jzSlsAJQdhTbtl6ktv/mQyePZXOUyCfyq/vOODu+CVxHS8dkOXiZyGJzyo
8/diwtxqd/lm/moAcczTqUB7cGmZgwYmeKMsYZdyQlRWlhueUWRPc6NraxxyYoiM
bE2N0jQXddnfWbHXaEZNzpBQU7WmYdruwhBELwzu3w7fAf3bZnQcaV0+fFr1AyhK
HCQEJVxlt7XnMdAMja+M3Rp0dw2C7aDyFcWBtzIynXSLxKZmdWiSYHyBITil+VP6
yxyOQsgZuCjcxQnkgRbCe2wNVowOeiuMxqtLFMdSzNCYgty3L9Cq6D9Egi3Nfxw=
=+bJq
-----END PGP SIGNATURE-----

--hWpEmYwtOzEddg2F--