Skip to main content
AmigoFish

High Availability PostgreSQL with Patroni – Full Setup Tutorial

From Techno Tim · · 54 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

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/@Technically-Tim

(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!

Back to Techno Tim · Report a problem