Akamai Developer | Set Up PostgreSQL Replication Using repmgr | PostgreSQL Failover Done Right @AkamaiDeveloper | Uploaded September 2024 | Updated October 2024, 2 hours ago.
New to Cloud Computing? Get started here with a $100 credit → 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 → linode.com/docs/guides/manage-replication-failover-on-postgresql-cluster-using-repmgr
Learn more about repmgr → repmgr.org
Subscribe to get notified of new episodes as they come out → youtube.com/channel/UCf8uu3IE42b6hRUusufEH8g?sub_confirmation=1
#AkamaiDeveloper #repmgr #PostgreSQL
Product: Akamai, repmgr, PostgreSQL; @KeepItTechie
New to Cloud Computing? Get started here with a $100 credit → 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 → linode.com/docs/guides/manage-replication-failover-on-postgresql-cluster-using-repmgr
Learn more about repmgr → repmgr.org
Subscribe to get notified of new episodes as they come out → youtube.com/channel/UCf8uu3IE42b6hRUusufEH8g?sub_confirmation=1
#AkamaiDeveloper #repmgr #PostgreSQL
Product: Akamai, repmgr, PostgreSQL; @KeepItTechie