Postgres Cluster: Master Patroni-Managed Clusters

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

What you'll learn

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

Requirements

• Basic database knowledge
• Willingness to learn

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

Who this course is for:

• DBAS
• IT Infrastructure Teams
• IT Students