Set Up PostgreSQL Replication Using repmgr | PostgreSQL Failover Done Right

Akamai Developers · Beginner ·🔧 Backend Engineering ·1y ago

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

Related AI Lessons

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
Up next
This Cop Was Held Accountable For His Brutality! #police #lawyer
Hampton Law
Watch →