PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Follow these steps to determine the extent of necessary backup tooling:

1. Create a spreadsheet with the following columns: Cluster Name, Environment, Streaming, Logical, DC, Size (GB), PITR, and Backup.
2. Create a row for each server indicating its Cluster Name based on the primary focus of the data.
3. For each row, set the corresponding attribute column as follows:
   • For Environment, use Production, Disaster Recovery, UAT, QA, or any other common internal indicator.
   • Specify the number of physical streaming replica nodes in the cluster.
   • If applicable, list the number of logical replica nodes; any node that may exist as a write target counts here.
   • If there are multiple data centers, list how many the cluster inhabits in the DC column. ...