Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Set Up PostgreSQL Replication Using repmgr - PostgreSQL Failover Tutorial

Linode via YouTube

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

Reviews

Start your review of Set Up PostgreSQL Replication Using repmgr - PostgreSQL Failover Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.