Set Up PostgreSQL Replication Using repmgr | PostgreSQL Failover Done Right
Key Takeaways
Sets up PostgreSQL replication using repmgr for high availability and failover
Original Description
New to Cloud Computing? Get started here with a $100 credit → https://www.linode.com/lp/youtube-viewers/?utm_source=youtube&utm_medium=dev_advocacy&utm_content=rmg_kit_09_17_24
@KeepItTechie showcases installing and using Replication Manager or repmgr, a replication and failover tool on PostgreSQL.
Chapters:
0:00 Introduction
0:37 In This Video
0:56 Repmgr Overview
2:34 Install PostgreSQL + repmgr
5:50 Configure PostreSQL
9:52 Restart the Server
10:25 Create a repmgr User & Database
12:28 Set Up SSH Keys
16:37 Configure repmgr
23:27 Add a Standby Command
26:09 Server Info Commands
27:53 Test the Failover
29:08 Conclusion
Read the doc for more information on managing failover → https://www.linode.com/docs/guides/manage-replication-failover-on-postgresql-cluster-using-repmgr/
Learn more about repmgr → https://www.repmgr.org/
Subscribe to get notified of new episodes as they come out → https://www.youtube.com/channel/UCf8uu3IE42b6hRUusufEH8g?sub_confirmation=1
#AkamaiDeveloper #repmgr #PostgreSQL
Product: Akamai, repmgr, PostgreSQL; @KeepItTechie
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: Database Integration
View skill →Related AI Lessons
⚡
⚡
⚡
⚡
Common Next.js Errors (and How I Solved Them)
Dev.to · gary killen
Applying Scalability in Backend (CodeBuddy)
Medium · LLM
Why Every Backend Developer Should Learn Nginx Before Going to Production
Medium · DevOps
Connecting Frontend to Backend: A Backend Engineer’s Reality Check
Medium · Programming
Chapters (13)
Introduction
0:37
In This Video
0:56
Repmgr Overview
2:34
Install PostgreSQL + repmgr
5:50
Configure PostreSQL
9:52
Restart the Server
10:25
Create a repmgr User & Database
12:28
Set Up SSH Keys
16:37
Configure repmgr
23:27
Add a Standby Command
26:09
Server Info Commands
27:53
Test the Failover
29:08
Conclusion
🎓
Tutor Explanation
DeepCamp AI