PHWSODownload
Established
Managing Postgresql High Availability by different methods
Published 8/2026
Created by Shruchin Boreda
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 26 Lectures ( 5h 2m ) | Size: 2.2 GB
Postgresql High Availability
What you'll learn
Managing Postgresql High Availability by different methods. Postgresql native replication repmgr patroni,keepalived,HAproxy,etcd,VRRPRequirements
Any RDBMS(Oracle,Postgresql,MySQL) AdministrationDescription
PostgreSQL High Availability: Build Production-Grade HA Clusters from Scratch
Master streaming replication, automated failover, load balancing, and disaster recovery to keep your PostgreSQL databases always online.
Course Description
PostgreSQL powers some of the world's most demanding applications - from fintech platforms to SaaS giants. But when downtime costs thousands of dollars per minute, a single database instance is a ticking time bomb.
This course is your complete, hands-on guide to building bulletproof PostgreSQL High Availability clusters that survive node failures, network splits, and hardware crashes without breaking a sweat.
Whether you're a DBA, DevOps engineer, backend developer, or SRE, you'll learn how to design, deploy, and operate production-grade HA architectures using industry-standard tools and battle-tested patterns.
What you'll learn
By the end of this course, you will be able to
Architect HA clusters using streaming replication and cascading replicas
Implement automated failover with Patroni, etcd, and Keepalived - no manual intervention required
Build a robust backup & PITR strategy with pgBackRest and WAL archiving
Monitor cluster health using pg_stat_statements
-->Overview of Postgresql High Availability
-->Introduction to Vagrant
-->Initilizating Vagrant
-->Setting up server through Vagrant
-->Setting up server with Postgres binaries through Vagrant
-->Settting up postgresql native replication
-->Setting up replication through repmgr
-->Overview on keepalived
-->Overview on etcd
-->Overview on VRRP
-->Overview on HAProxy
-->Overview on VIP
-->Setting up Patroni prerequisites
-->Setting up servers for Patroni
-->Setting up etcd
-->Installing Binaries
-->Installing etcd
-->Installing HAProxy
-->Installing postgres client
-->Installing dependency rpms
-->Administrating Patroni
Course Curriculum Highlights
Streaming Replication Deep Dive Physical replication slots, WAL shipping, replication lag tuning
Patroni Cluster Setup etcd/ZooKeeper consensus, REST API, TTL-based leader election
Failover Automation Automatic promotion
Read Scaling Load balancing reads across replicas
pg_hba.conf best practices
Who this course is for
DBAs, PostgreSQL developers,Database EngineersHomepage
Code:
https://www.udemy.com/course/managing-postgresql-high-availability-by-different-methodsDOWNLOAD LINKS
