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
# 🐕 PgDog + PostgreSQL 18 — 2 Node HA Setup (Ubuntu 24.04)
Note : Flow the Process shown in video 📽️.
✨ 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!
Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
https://www.chirags.in
#PgDog #PostgreSQL18 #PostgreSQL #HighAvailability #Ubuntu2404 #DatabaseHA #PostgresCluster #PostgreSQLReplication #PgDogHA #PostgreSQLTutorial #PostgreSQLSetup #LinuxServer #DatabaseAdmin #OpenSourceDB #PostgreSQLGuide
