Postgres Cluster: Master Patroni-Managed Clusters

Name: Postgres Cluster: Master Patroni-Managed Clusters
Rating: 3.8 (14 reviews)

Learn how to build a robust PostgreSQL cluster on Linux using Patroni, ETCD, HAProxy and Keepalived

Created bySandro Servino

Last updated 9/2025

English

What you'll learn

Install and configure Oracle Linux
Create virtual machines
Install and configure Postgres
Configure a complete Postgres cluster environment with Patroni, etcd, haproxy, and keepalived

Course content

5 sections • 48 lectures • 12h 22m total length

Introduction2:31

Lesson 154_Oracle Linux Installation_Part119:41
Learn to install Oracle on Linux by creating a VirtualBox VM and configuring Oracle Linux, including downloading the ISO and following prerequisites, and using bridged networking for a networked environment.
Lesson 154_Oracle Linux Installation_Part213:52
Demonstrates installing Oracle Linux in a VirtualBox VM, mounting the ISO, configuring language, keyboard, time zone, and root password, with practical setup tips.
155_Oracle Linux Installation, partitioning the disk with LVM28:28
156_Finishing the Oracle Linux installation and logging in for the first time4:44
157_Changing firewall, Putty and allowing external access to root17:09
158_Changing the Linux IP11:29
159_Learning basic Linux commands26:26
160_Learning basic Linux commands17:21
161_Linux directory structure20:15
162_Updating Linux packages14:00
163_Linux, checking df h and ls command17:58
164_Linux, checking free and top command15:19
Use the free -m command to view total, used, and available memory and swap on Linux, then use top to monitor real-time CPU and memory usage by processes.
165_Linux, checking chmod command12:11
166_Linux, checking chown command, creating users and groups14:34
Learn how to use the chown command to change file and directory ownership in Linux, including owner and group management, root privileges, and owner:group syntax with practical examples.
167_Linux, checking cp and mv command13:01
168_Linux, checking find and grep command9:15
169_Linux, checking tail command and $path variable13:27

011.1 Installing Postgres on Oracle Linux, First Method_Part112:37
011.1 Installing Postgres on Oracle Linux, First Method_Part223:49
011.2 Installing Postgres on Oracle Linux, Second Method_Part120:19
Install Postgres on Oracle Linux using the offline second method by copying the installer from another machine via FTP, then initialize the database and start the service.
011.2 Installing Postgres on Oracle Linux, Second Method_Part28:36
Change to the postgres linux user, connect to the Postgres database with PgAdmin and SQL, and create databases, tables, and users while enforcing passwords.
011.3 Connecting to Postgres on Linux with PGAdmin19:10
011.4 Increasing postgres user security on Oracle Linux4:12
Switch to the Postgres context, edit the pg_hba.conf to set md5 authentication, and restart Postgres to require a password for Postgres connections on Oracle Linux.

012.1 High Availability Concepts, Cluster, Patroni, etcd, and HAProxy_Part120:34
012.1 High Availability Concepts, Cluster, Patroni, etcd, and HAProxy_Part224:55
012.2 About quorum in the Cluster18:29
Explain how quorum ensures a single leader in a Patroni managed PostgreSQL cluster by requiring majority among three or more nodes, preventing split-brain and ensuring reliable failover.
012.3 Installing ETCD18:13
Install etcd on the first cluster node and configure it for cluster management, then stop and disable PostgreSQL so Patroni can manage it and handle failover.
012.4 Configuring ETCD11:26
Configure and activate etcd across all nodes in a Patroni-managed Postgres cluster, establishing a quorum-driven failover with leader and replica awareness.
012.5 Configuring ETCD6:57
Configure etcd for a Patroni-managed Postgres cluster, create and save config blocks, restart services, and troubleshoot startup messages in preparation for installing Patroni.
012.6 Installing, Configuring, and Testing Patroni26:28
Install and configure Patroni to manage a PostgreSQL cluster, create a replication user, set up systemd service, start Patroni, and verify leader status and failover readiness with etcd and HAProxy.
012.7 Installing and Configuring HAProxy18:55
Install and configure HAProxy across all nodes to route writes to the leader via Patroni, balance reads across replicas, and expose a single proxy IP with health portal on 8080.
012.8 Creating a virtual IP with Keepalived16:15
012.9 Some information about Physical and Logical Replication in Postgres Clust7:29
012.10 Cloning our VM with leader node and setting a new IP17:20
012.11 Configuring ETCD on our first Cluster replica16:50
012.12 Configuring Patroni on Our First Cluster Replica_Part114:30
Configure Patroni on the first cluster replica, joining 189 to the etcd cluster for a three-node high-availability setup. Resolve replication permission errors by authorizing the replicator user and verifying status.
012.12 Configuring Patroni on Our First Cluster Replica_Part223:54
012.13 Finishing the configuration of the first replica of the Cluster_Part17:51
012.13 Finishing the configuration of the first replica of the Cluster_Part228:29
012.14 Cloning our second VM and setting a new IP11:50
Clone the existing vm 189 to create node 190 for a three-node patroni-managed postgres cluster, then change its ip and prepare it to join the high-availability quorum.
012.15 Configuring Patroni and etcd on our second Cluster Replica21:11
012.16 Trying to resolve a problem with one of the replica nodes5:30
012.17 Solving the Patroni problem15:34
012.18 Finalizing the configuration of Patroni, etcd, haproxy and keepalived17:37
Test and finalize Patroni, etcd, HAProxy, and keepalived configuration by performing failover tests, validating leader and replicas, and configuring asynchronous replication with plans to enable synchronous replication.
012.19 Performing quorum testing with a 3-node cluster7:16
Explore quorum testing in a three-node patroni-managed Postgres cluster, simulate node failures, observe auto failover with a majority, and prepare for synchronous versus asynchronous replication.
012.20 Changing replication from asynchronous to synchronous in the cluster20:47

Requirements

Basic PostgreSQL knowledge

Description

In this 100% hands-on course, you will learn how to set up high availability with PostgreSQL using the powerful Patroni orchestrator, in a modern and professional Linux environment.

If you want to ensure your PostgreSQL databases remain available even in the event of failures, this course is for you.

Throughout the lessons, we’ll build a fully functional and robust cluster together, using:

PostgreSQL — the most advanced open-source database on the market
Patroni — the orchestration tool that manages automatic failover and replication
ETCD — the distributed configuration store that ensures cluster-wide consensus
HAProxy — the load balancer that automatically routes connections to the primary node
Keepalived — used to set up a floating virtual IP to guarantee continuous access

You will learn:

What quorum is and how it works in a cluster
How to avoid issues like split-brain
How to perform both automatic and manual failover safely
How to monitor the cluster and maintain data integrity
How to simulate real-world failure and recovery scenarios
Best practices for production environments

This course is ideal for DBAs, DevOps engineers, SREs, and Linux administrators who want to take their PostgreSQL infrastructure to the next level.

Prerequisites

Basic knowledge of PostgreSQL (but don’t worry — if you’re new to it, I have a complete PostgreSQL course available here on Udemy)
A strong desire to learn by doing, with real-world simulations

Enjoy the course, everyone!

Prof. Sandro Servino

Who this course is for:

DBAs
IT Infrastructure Teams
IT Students

Postgres Cluster: Master Patroni-Managed Clusters

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Oracle Linux Installation and Basic Linux Knowledge17 lectures • 4hr 29min

Installing Postgres Database on Oracle Linux6 lectures • 1hr 29min

Setting Up Postgres Cluster with Patroni23 lectures • 6hr 18min

Course Closing1 lecture • 4min

Requirements

Description

Who this course is for: