MENU

Fun & Interesting

Set Up PostgreSQL Replication Using repmgr | PostgreSQL Failover Done Right

Akamai Developer 3,106 7 months ago
Video Not Working? Fix It Now

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

Comment