PostgreSQL 18 Replication & Failover Using repmgr |2 Node Cluster Setup on Ubuntu
Static IP addresses for all nodes.
+------------+------------------+---------------+
| Role | IP Address | Hostname |
+------------+------------------+---------------+
| Primary DB | 192.168.136.128 | server1 |
+------------+------------------+---------------+
| Replica DB | 192.168.136.129 | server2 |
+------------+------------------+---------------+
What Is repmgr?
Repmgr is an open source suite for managing PostgreSQL HA clusters. It closely integrates with PostgreSQL to configure a primary node, clone replica nodes, monitor the HA cluster, and perform a failover. Repmgr supports a single read-write primary server and one or more read-only standby nodes, also known as replicas. This guide focuses on repmgr because it is an efficient and robust solution with long-standing popularity in the database management area.
The complete list of steps required to provision PostgreSQL and repmgr follows this sequence:
1. Install PostgreSQL on both nodes.
2. Access and secure PostgreSQL on both nodes.
3. Install repmgr on both nodes.
4. Enable SSH connectivity between the nodes.
5. Create a repmgr user on the primary node.
6. Configure the database replication settings in the PostgreSQL configuration file on the primary.
7. Configure the PostgreSQL authentication settings on the primary.
8. Configure the repmgr HA cluster settings on both nodes.
9. Register the primary server.
10. Clone and register the standby server.
--------------------------------------------------------------------
⚠️ Disclaimer / अस्वीकरण
I do not own any of the content, materials, or resources used or shown in this video. All trademarks, product names, company names, and logos belong to their respective owners.
This video has been created solely for educational, informational, and reference purposes under the principles of Fair Use (Section 107 of the Copyright Act, 1976), which permits limited use of copyrighted material for purposes such as education, commentary, research, teaching, and news reporting.
No copyright infringement is intended.
If you are a copyright owner and believe that any material in this video violates your rights, please contact me directly. I will review the content and take immediate action — such as removal or proper credit.
📜 This channel shares publicly available educational materials for learning and awareness purposes only. Please always refer to official websites or sources for the most accurate and updated information.
------------------------------------------------------------------------
𝐒𝐨𝐜𝐢𝐚𝐥 𝐋𝐢𝐧𝐤𝐬:
🎥 𝐘𝐨𝐮𝐭𝐮𝐛𝐞: / @chiragmahtoofficial
📷 𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: / chirag_._mahto
🩵 𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: / chittrmahto
🤷♂️ 𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: / chittrmahto
WhatsAPP Group: https://whatsapp.com/channel/0029VbBg...
Telegram Channel : https://t.me/+GAATbmOU4z1mMDY9
Note : Flow the Process shown in video 📽️.
✨ Share this YouTube Video with your friends and colleagues and help them get certified too!
📽️ For any doubts and queries, please write in the YouTube video comments section.
🔔 Subscribe to my channel for more FREE certification tutorials and learning content.
/ @chiragmahtoofficial
💛Don't forget to, 💘Follow, 💝Like, Share 💙&, Comment!
Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
https://www.chirags.in
#ChiragTutorial #Chirag #ChittRanjanMahto #ChiragMahto #PostgreSQL18 #PostgreSQL #repmgr #PostgreSQLReplication #FailoverCluster #HighAvailability #DatabaseCluster #PostgreSQLSetup #Ubuntu2404 #LinuxServer #DBA #PostgreSQLTutorial #PostgreSQLAdmin #PostgreSQLHighAvailability #PostgreSQLFailover #PostgreSQLCluster #OpenSourceDatabase #ReplicationSetup #PostgreSQLGuide #ChiragTech #ChiragTutorials #ChittRanjan #DatabaseManagement