posts/postgresql-high-availability/

[giscus[bot]]

posts/postgresql-high-availability/

Today is the day that you start running PostgresSQL in a cluster! In this tutorial we’ll be setting up a production ready Postgres cluster that’s highly available and fault tolerant using PostgreSQL, etcd, Patroni, HA Proxy, and keepalived. This resilient combination will ensure that you can always reach your database even when a node in the cluster goes down!

https://technotim.live/posts/postgresql-high-availability/

[Po3Tato]

Great walk through. Typo on the VIP "ping 192.168.60.100" instead of "192.168.60.110". Also i am working to figure out how to have the network being handled by Tailscale. Stuck at the VIP part but gaining some progress.

[mayrink85]

Also noticed this @Po3Tato and have submitted a PR to fix this typo.

[m1ckyb]

In the Verifying Our Postgres Cluster section, the ports are wrong, you have :8080 but should be 8008 :)

But thanks for this guide..

[Po3Tato]

Got a question. Getting this error
'''
mn-postgresql-srv02 etcd[1358]: {"level":"warn","ts":"2024-12-28T23:42:08.875944Z","caller":"embed/config_logging.go:170","msg":"rejected connection on client endpoint","remote-addr":"127.0.0.1:58096","server-name":"","error":"tls: first record does not look like a TLS handshake"}
'''
My certs look fine. Got any tips?

[mayrink85]

Hi @m1ckyb I saw the same thing and have submitted a PR to fix this.