Patroni + etcd PostgreSQL HA in Docker | Auto Failover 🐘 #docker #postgresql #etcd #highavailability

🎥 YouTube Full video:

https://youtu.be/boc_RJfBV-g

Build a full Patroni + etcd PostgreSQL HA cluster in Docker with automatic failover, end-to-end. 🐘⚙️🐘

We’ll do everything on Ubuntu 24.04 LTS (your server, e.g. 192.168.136.128) using Docker + Docker Compose.

## 🔁 Optional: Bring Old Node Back as Replica

You can wipe node1-data/ and rejoin node1 as a fresh Patroni member (it will clone from current leader automatically), but for this tutorial the key is:

* etcd + Patroni coordinate cluster state
* One leader, one replica
* Leader crash → automatic promotion
* Data preserved and new writes possible

## 🧾 Quick Recap (great for your slide)

1. Build Patroni+Postgres image from postgres:16
2. Run etcd as DCS in Docker
3. Configure two Patroni nodes via YAML (scope, etcd, bootstrap, postgresql)
4. Start cluster with docker compose up -d
5. Test leader/replica with psql and pg_is_in_recovery()
6. Simulate failure by stopping leader container → Patroni promotes replica automatically

--------------------------------------------------------------------
######## ⚠️ Disclaimer / अस्वीकरण ########
1️⃣ All trademarks, logos, and names belong to their respective owners.
2️⃣ This video is made only for educational & informational purposes under Fair Use (Section 107, Copyright Act 1976).
3️⃣ No copyright infringement intended.
4️⃣ For any copyright concerns, email 📩 inchirags@gmail.com — action will be taken promptly.

## 🌐 👇 Follow & Support:
🎥 YouTube: https://www.youtube.com/@ChiragMahtoOfficial
📷 Instagram: https://www.instagram.com/chirag_._mahto
💼 LinkedIn: https://linkedin.com/in/chittrmahto
📘 Facebook: https://www.facebook.com/chittrmahto
💬 WhatsApp Channel: https://whatsapp.com/channel/0029VbBgm16002T93KB16U12
💬 Telegram Channel: https://t.me/+GAATbmOU4z1mMDY9

📘 Note: Follow the process exactly as shown in the video.
💾 DM me for paid PDF/Document → 📩 inchirags@gmail.com

✨ Share this tutorial with your friends & colleagues!
💬 Drop your questions in the YouTube comments — I’ll reply personally.

🔔 Subscribe for FREE tutorial and Certification Tutorials!
🔥 Don’t forget to 💛 LIKE, 💘 SHARE, 💝 COMMENT, & 💙 SUBSCRIBE to @ChiragTutorial 💯

Thanks & Regards,
💫 Chitt Ranjan Mahto — “CHIRAG” 💫
🌍 https://www.chirags.in

#chiragtutorial #chirag #chittranjanmahto #chiragmahto #postgresql #patroni #etcd #docker #highavailability #autofailover #dbacluster #postgresha #devops

Видео Patroni + etcd PostgreSQL HA in Docker | Auto Failover 🐘 #docker #postgresql #etcd #highavailability канала Chirag Mahto