Overview
Learn how to set up PostgreSQL replication using repmgr in this comprehensive 30-minute tutorial. Explore the process of installing and configuring Replication Manager (repmgr), a powerful replication and failover tool for PostgreSQL databases. Follow step-by-step instructions to install PostgreSQL and repmgr, configure the database, create necessary users and databases, set up SSH keys, and configure repmgr for optimal performance. Discover how to add standby commands, use server info commands, and test failover scenarios. Gain valuable insights into managing replication and failover in PostgreSQL clusters, ensuring high availability and data integrity for your applications.
Syllabus
Introduction
In This Video
Repmgr Overview
Install PostgreSQL + repmgr
Configure PostreSQL
Restart the Server
Create a repmgr User & Database
Set Up SSH Keys
Configure repmgr
Add a Standby Command
Server Info Commands
Test the Failover
Conclusion
Taught by
Linode