High Availability PostgresDB on K8s

This may help - https://phoenixnap.com/kb/postgresql-kubernetes

[https://phoenixnap.com/kb/wp-content/uploads/2021/08/how-to-deploy-postgresql-on-kubernetes.png]<https://phoenixnap.com/kb/postgresql-kubernetes>
How to Deploy PostgreSQL on Kubernetes {Helm Chart or Manual Config} - Knowledge Base by phoenixNAP<https://phoenixnap.com/kb/postgresql-kubernetes&gt;
Introduction. PostgreSQL is a reliable and robust relational database system featuring ACID-compliant transactions.It is designed to handle workloads of all sizes, making it a good fit for personal use and large-scale deployments such as data warehouses, big data servers, or web services.. Deploying PostgreSQL on Kubernetes creates a scalable and portable PostgreSQL instance, leveraging the ...
phoenixnap.com

________________________________
From: Marco Schmucki <marco.schmucki@revendex.com>
Sent: Friday, August 19, 2022 11:09 AM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: High Availability PostgresDB on K8s

Hi all

I want to run an HA-Postgres-DB on a Kubernetes cluster for testing purposes (Proof of Concept).

Do you have some links or documentation?

Many thanks for your feedback!

Best regards,

Marco

Hi,

Am Freitag, 19. August 2022, 17:09:35 CEST schrieb Marco Schmucki:

I want to run an HA-Postgres-DB on a Kubernetes cluster for testing purposes
(Proof of Concept).

Do you have some links or documentation?

We're usually using Bitnami's Helm charts [1]https://bitnami.com/stack/postgresql/helm, [2]https://github.com/bitnami/charts/tree/master/bitnami/postgresql/ #installing-the-chart to deploy PostgreSQL into
our K8S clusters. They also have -ha variants that might fit your needs,
though I haven't tested them myself.

Be aware, that you'll get a single-master-multiple-replica, so you still only
have one Postgres-instance actually *writing* data. As long as most of the
traffic is reading traffic, that might just work well; if you have a lot of
writing traffic, you will be limited by the master pod, the node it is running
on, and of course the underlying PVC.

If you need multi-master, you might have a look at CockroachDB [3]https://www.cockroachlabs.com/product/kubernetes/ which
mostly Postgres-compatible.

[1]: https://bitnami.com/stack/postgresql/helm
[2]: https://github.com/bitnami/charts/tree/master/bitnami/postgresql/ #installing-the-chart
#installing-the-chart
[3]: https://www.cockroachlabs.com/product/kubernetes/

--
MfG Jan