Thread: High Availability PostgresDB on K8s

High Availability PostgresDB on K8s

From
Marco Schmucki
Date:

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

 

Re: High Availability PostgresDB on K8s

From
Sumit Sengupta
Date:




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

 

Re: High Availability PostgresDB on K8s

From
Jan Kohnert
Date:
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], [2] 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] which 
mostly Postgres-compatible.

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

-- 
MfG Jan