High Availability PostgreSQL with Patroni – Full Setup Tutorial

Ready to take PostgreSQL to the next level? In this in-depth tutorial, we’ll walk through setting up a self-hosted, production-ready PostgreSQL cluster with high availability, automatic failover, and scalability in mind. We’re doing it all from scratch using: - PostgreSQL - Patroni - etcd - HAProxy - Keepalived By the end of this video, you’ll have a solid, battle-tested setup that keeps your database online—even if a node goes down. Video Notes: https://technotim.live/posts/postgresql-high-availability/ Merch Shop ?️: https://l.technotim.live/shop Support me on Patreon: https://www.patreon.com/technotim Sponsor me on GitHub: https://github.com/sponsors/timothystewart6 Subscribe on Twitch: https://www.twitch.tv/technotim Become a YouTube member: https://www.youtube.com/channel/UCOk-gHyjcWZNj3Br4oxwh0A/join Gear Recommendations: https://l.technotim.live/gear Get Help in Our Discord Community: https://l.technotim.live/discord 2nd channel: https://www.youtube.com/@TechnoTimTinkers (Affiliate links may be included in this description. I may receive a small commission at no cost to you.) 00:00 - Intro 01:17 - Components that make a HA Postgres Cluster 02:18 - etcd's Role 02:41 - Patroni's Role 03:51 - HA Proxy's Role 05:22 - keepalived's role 06:24 - Documentation 06:33 - Requirements 08:06 - Automation? 08:51 - Installing PostgreSQL 09:53 - Install etcd 12:47 - etcd Certificates 18:01 - Configuring etcd 22:58 - Starting etcd 23:20 - Verifying etcd cluster 25:29 - Configuring Postgres & Patroni 25:51 - Postgres Certificates 27:53 - Certificate ACLs 28:48 - Installing Patroni 29:05 - Configuring Patroni 34:00 - Patroni Certificates 34:44 - Starting Patroni (and our HA Cluster!) 35:49 - Reconfiguring etcd Cluster 36:38 - Verifying our Cluster with Patroni 37:18 - Installing HA Proxy 38:08 - Configuring HA Proxy 40:43 - Starting HA Proxy 41:15 - Installing keepalived 41:46 - Configuring keepalived 45:59 - Starting keepalived 46:29 - Verifying keepalived 46:43 - Connecting to Cluster with PGAdmin 48:06 - Creating Data in our HA Cluster 48:54 - Testing HA: Taking Down a Postgres Node 50:38 - Testing HA: Taking Down HA Proxy & keepalived Nodes 51:50 - Testing HA: Bringing Nodes Up and Verifying Replication 53:58 - More HA Content Coming Thank you for watching!