PostgreSQL High Availability & Patroni Cluster Manager




3 days

Dates & Times

See available dates for this High Availability & Patroni course!
If there is no date and time available for a certain training you are interested in, please contact us.

See dates  >>


The training takes 3 days.


This course is intended for PostgreSQL users who are interested in fully automating high availability operations.
The course first gives an overview of the general high availability landscape in PostgreSQL clusters and then focuses on the very popular (open source) cluster manager “Patroni”.

Audience Requirements

Target group for this course are experienced PostgreSQL users with at least basic Linux knowledge (command line, editing of configuration files)


Overview of PostgreSQL High Availability (HA)

  • binary replication
  • typical replication problems and solutions
  • built-in HA mechanisms
  • switchover and failover
  • logical replication

HA automation

  • basic concepts
  • standard HA problems
  • decisions with consensus
  • different approaches


  • basic idea & introduction
  • installation
  • configuration & operation
  • common problems


  • extended functionalities
  • postgresql.conf + pg_hba.conf replacement

Routing of client requests

  • libpq/JDBC
  • vip manager
  • HAProxy

Updates and upgrades

  • PostgreSQL updates
  • Patroni updates


Contact us to sign up for this course >>