Mastering Postgresql High Availability
Published 10/2025
Created by Rajeev Raj
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 12 Lectures ( 3h 2m) | Size: 1.6 GB
Mastering PostgreSQL High Availability: Streaming Replication, Failover & Repmgr Hands-On
What you'll learn
PostgreSQL 18 Installation on Linux 9
PostgreSQL 17 Installation on Linux
Configure primary and standby servers for streaming replication
Set up repmgr for cluster management and automatic failover
Perform live failover and switchover tests
Requirements
Basic knowledge of PostgreSQL
Description
High Availability is the beating heart of enterprise PostgreSQL systems. In this practical, hands-on course, you'll learn to design, build, and manage a fault-tolerant PostgreSQL environment using streaming replication, repmgr, and automatic failover.You'll work directly with PostgreSQL 17 on Linux (RHEL/CentOS/Oracle Linux 9), simulating real data-center conditions. Whether you're a DBA, DevOps engineer, or architect, this course will teach you exactly how to prevent downtime and ensure database resilience.What You'll LearnConfigure primary and standby servers for streaming replicationSet up repmgr for cluster management and automatic failoverPerform live failover and switchover testsManage replication slots, WAL archiving, and monitoringTroubleshoot replication lag and cluster recoveryUnderstand synchronous vs asynchronous replicationBuild production-ready HA architecture for PostgreSQL 17This course will provides a step-by-step process to configure streaming replication in PostgreSQL 17 using asynchronous mode between two virtual machines. It includes system configuration, PostgreSQL installation, repmgr setup, and replication verification.Course Sections (Proposed Structure)Introduction to High Availability ConceptsPostgreSQL Installation & Environment SetupStreaming Replication in Depthrepmgr Installation & ConfigurationFailover & Switchover ManagementMonitoring & Troubleshooting HA ClustersEnterprise-Level HA Architecture DesignFinal Demo: Real-Time Failover SimulationThis course is designed for professionals who want to build robust, fault-tolerant PostgreSQL environments and take their DBA or DevOps skills to the next level.
Who this course is for
Database Administrators (DBAs)
Database Administrators (DBAs) who want to master streaming replication, repmgr, and high availability concepts.
System Administrators / DevOps Engineers looking to implement PostgreSQL clusters in production.
Software Engineers or Architect
Students aiming to specialize in database management and backend reliability
Homepage
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
