Thomas Shaun M. PostgreSQL High Availability Cookbook

2nd Ed. — Packt Publishing - ebooks Account, 2017. — 530 p. — ISBN10: 178712553X, ISBN13: 978-1787125537.Protect your data with PostgreSQL replication and management tools such as Slony, Bucardo, pglogical, and WAL-E
Hardware planning to help your database run efficiently
Prepare for catastrophes and prevent them before they happen
Reduce database resource contention with connection pooling using pgpool and PgBouncer
Automate monitoring and alerts to visualize cluster activity using Nagios and collected
Construct a robust software stack that can detect and fix outages
Learn simple PostgreSQL High Availability with Patroni, or dive into the full power of Pacemaker.Hardware Planning,
Handling and Avoiding Downtime,
Pooling Resources,
Troubleshooting,
Monitoring,
Replication,
Replication Management Tools,
Simple Stack,
Advanced Stack,
Cluster Control,
Data Distribution.