Skip to playerSkip to main content
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

Category

📚
Learning
Be the first to comment
Add your comment

Recommended