What is PgDog? PgDog is a High Availability (HA) and automatic failover manager for PostgreSQL — similar in purpose to tools like repmgr, Patroni, or pg_auto_failover.
It’s a modern, lightweight, and agent-based solution designed to monitor PostgreSQL clusters, handle node failures, and promote standby nodes to primary automatically when needed.
Step-by-step tutorial for setting up PgDog + PostgreSQL 18 High-Availability (HA) on Ubuntu 24.04 LTS
🧭 Architecture -------------------------------------------------------------------------------------- Role IP Address Description -------------------------------------------------------------------------------------- Primary Server 192.168.136.128 PostgreSQL 18 Primary Server Replica Server 192.168.136.129 PostgreSQL 18 Replica Server -------------------------------------------------------------------------------------- Default password everywhere: admin@123
✨ Share this Video with your friends and colleagues and help them get certified too! 📽️ For any doubts and queries, please write in the video comments section.
💛Don't forget to, 💘Follow, 💝Like, Share 💙&, Comment if you found this useful!
Be the first to comment