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