PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

We will be filling out a very short spreadsheet inventory of our PostgreSQL server clusters. In this context, a cluster is an independent combination of primary nodes and associated standby or replica systems. Some organizations have several of these, so we must have a record of them all to ensure each can be replaced in the case of a total server loss. Even if we choose not to use more advanced backup software, this will serve as a valuable source of inventory and documentation for our database infrastructure.

Be sure to have access to a spreadsheet program before continuing. We also strongly recommend a diagram of all PostgreSQL servers for each segment of your database architecture. This will likely include production and ...