• Start page
  • Courses
  • PostgreSQL Administration Workshop - High Availability Architecture

PostgreSQL Administration Workshop - High Availability Architecture

This intensive two-day course provides a masterclass in PostgreSQL High Availability and Scalability. Participants will journey through the foundational mechanics of Physical Replication and Connection Pooling, before mastering the industry's leading orchestration frameworks: Patroni and Pacemaker.

By combining theoretical architectural knowledge with practical failover scenarios and traffic management via HAProxy, this training equips database administrators with the tools to design, deploy, and maintain resilient, self-healing database clusters in production environments.

The lab activities will be on the 3 virtual machines on Oracle VirtualBox Manager. The guest operating system on these virtual machines is Oracle Linux.

Course Objectives

After completing this course, participants will be able to:

  • Design highly available PostgreSQL architectures for production environments
  • Implement and manage PostgreSQL physical replication
  • Configure and optimize streaming replication between database nodes
  • Deploy and administer PostgreSQL clusters using Patroni
  • Implement automated failover and recovery processes
  • Configure and manage high availability solutions using Pacemaker
  • Use HAProxy to provide load balancing and traffic routing for PostgreSQL workloads
  • Monitor cluster health and validate failover scenarios
  • Troubleshoot common replication and high availability issues
  • Build resilient, self-healing PostgreSQL database environments

Target Audience

  • Database Administrators.

Prerequisites

Delegates attending this training should have attended the “PostgreSQL Administration Workshop” course, or have equivalent experience.

About the instructor Cuneyt Yilmaz

Cuneyt is working as senior instructor and consultant with specialty in Analytics, Business Intelligence, Data Management and Performance Tuning. He is a certified trainer for Microsoft and Oracle, and he also delivers training on MongoDB and PostgreSQL.

Cuneyt is based in Istanbul but has been working with customers in 35 countries across the Nordics and EMEA over the last 15 years. He combines top technology skills with his kindness and strong pedagogical skills. We dare to say, nobody leaves Cuneyt`s classroom disappointed! 

Module 1: Replication Overview

  • Replication Overview
  • Replication Slots
  • Switchover
  • Failover

Module 2: The Role of pgBouncer

  • Installation & Configuration
  • Connection Management
  • Failover Tests

Module 3: Using Patroni as the Cluster Manager

  • Overview of Cluster Manager
  • The Benefit of Patroni
  • Etcd as a Distributed Content Store (DCS)
  • Installation and Configuration
  • Switchover-Failover Tests

Module 4: HAProxy Overview

  • High Availability using HAProxy
  • Health Checking Methods
  • Traffic Direction
  • Switchover-Failover Tests

Module 5: Using Pacemaker as the Cluster Manager

  • Pacemaker Overview
  • Pros and Cons of Pacemaker
  • High Level steps of implementation of Pacemaker

Practical information

Duration: 2 days
Price: 16 500 NOK
Language: English
Format: Available as open enrollment or private company training

FAQ

Hvordan gjennomføres kurset?
Kurset kan gjennomføres som et åpent kurs eller som bedriftsinternt kurs. Du kan delta enten fysisk i klasserom eller virtuelt.

Hvem passer kurset for?
Kurset passer for databaseadministratorer, databasearkitekter, plattformingeniører og andre som har ansvar for drift og tilgjengelighet av PostgreSQL-miljøer.

Hva lærer jeg i løpet av kurset?
Du lærer hvordan du designer, implementerer og administrerer PostgreSQL-løsninger med høy tilgjengelighet ved hjelp av teknologier som fysisk replikering, Patroni, Pacemaker og HAProxy.

Er kurset praktisk rettet?
Ja. Kurset inneholder omfattende hands-on lab-øvelser hvor deltakerne bygger og administrerer PostgreSQL-klynger i et virtuelt miljø. Labene gjennomføres på tre virtuelle maskiner i Oracle VirtualBox med Oracle Linux som operativsystem.

Hvilke temaer dekkes i kurset?
Kurset dekker blant annet PostgreSQL Physical Replication, Connection Pooling, Patroni, Pacemaker, HAProxy, failover-mekanismer, trafikkstyring, høy tilgjengelighet og skalerbarhet.

Hvilke forkunnskaper anbefales?
Det anbefales erfaring med PostgreSQL-administrasjon og grunnleggende kunnskap om Linux-miljøer.

Hva gjør dette kurset unikt?
Kurset kombinerer teori og praktiske øvelser for å gi deltakerne erfaring med både design, implementering og drift av robuste PostgreSQL-klynger. Fokus på Patroni, Pacemaker og HAProxy gir innsikt i teknologier som ofte brukes i moderne produksjonsmiljøer.

Relevant courses

Other subject areas