What is PgDog?<br />PgDog is a High Availability (HA) and automatic failover manager for PostgreSQL — similar in purpose to tools like repmgr, Patroni, or pg_auto_failover.<br /><br />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.<br /><br />Step-by-step tutorial for setting up PgDog + PostgreSQL 18 High-Availability (HA) on Ubuntu 24.04 LTS<br /><br />🧭 Architecture<br />--------------------------------------------------------------------------------------<br />Role IP Address Description<br />--------------------------------------------------------------------------------------<br />Primary Server 192.168.136.128 PostgreSQL 18 Primary Server<br />Replica Server 192.168.136.129 PostgreSQL 18 Replica Server<br />--------------------------------------------------------------------------------------<br />Default password everywhere: admin@123<br /><br /># 🐕 PgDog + PostgreSQL 18 — 2 Node HA Setup (Ubuntu 24.04)<br /><br />Note : Flow the Process shown in video 📽️.<br /><br />✨ Share this Video with your friends and colleagues and help them get certified too!<br />📽️ For any doubts and queries, please write in the video comments section.<br /><br />💛Don't forget to, 💘Follow, 💝Like, Share 💙&, Comment if you found this useful!<br /><br />Thanks & Regards,<br />Chitt Ranjan Mahto "Chirag"<br />https://www.chirags.in<br /><br />#PgDog #PostgreSQL18 #PostgreSQL #HighAvailability #Ubuntu2404 #DatabaseHA #PostgresCluster #PostgreSQLReplication #PgDogHA #PostgreSQLTutorial #PostgreSQLSetup #LinuxServer #DatabaseAdmin #OpenSourceDB #PostgreSQLGuide
