So far in this book, we've discussed quite an array of functionality and methodology dedicated to keeping PostgreSQL systems online. By now, we have a burgeoning menagerie of replication utilities, system monitoring tools, connection pooling layers, failover and cluster automation frameworks, and even a handful of troubleshooting tips.
We then moved on to combining several of these techniques and a few others to create a software stack that automates and protects a PostgreSQL cluster. However, despite the power demonstrated in these chapters on repmgr and Patroni, they still rely primarily on PostgreSQL replication to safeguard replicated data. If we have an extremely high transaction throughput, even PostgreSQL replication may be too slow to fully resist data loss in the event of a server outage.
So, what tools can we use to safeguard our critical...
