Re: Running PostgreSQL in Kubernetes?

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(at)fidonet