Running PostgreSQL in Kubernetes?

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Running PostgreSQL in Kubernetes?
Date: 2021-07-26 10:36:22
Message-ID: YP6QJja3b+2nZ3z7@admin.sibptus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Colleagues,

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.

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2021-07-26 12:00:36 Re: Running PostgreSQL in Kubernetes?
Previous Message Ian Lawrence Barwick 2021-07-26 01:26:56 Re: Issue repmgr 5.2.1 switchover postgres 12 on RHEL8 SELinux enforcing