PostgreSQL 12 high availability cookbook : over 100 recipes to design a highly available server with the advanced features of PostgreSQL 12 / Shaun Thomas. [O'Reilly electronic resources]
Table of ContentsArchitectural ConsiderationsHardware PlanningMinimizing DowntimeProxy and Pooling ResourcesTroubleshootingMonitoringPostgreSQL ReplicationBackup ManagementHigh Availability with repmgrHigh Availability with PatroniLow-Level Server MirroringHigh Availability via PacemakerHigh Availability with Multi-Master ReplicationData DistributionZero-downtime Upgrades.
Summary
Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monitor and automate your way to reassuring high availability.