PostgreSQL High Availability & Patroni Cluster Manager

AGENDA

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

Patroni

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

Patronictl

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

Routing of client requests

• libpq/JDBC
• vip manager
• HAProxy

Updates and upgrades

• PostgreSQL updates
• Patroni updates