How it works...

The idea behind this spreadsheet is that we want to list every connection between every server. This means some servers may be listed multiple times. With this in mind, we start with six columns to track important attributes. This example spreadsheet represents part of our architecture in the introduction:

As the current production server has no data source, we leave that field blank. Otherwise, each row has important attributes. The Environment column, for instance, helps us decide whether or not we need tools to coordinate data movement between data centers or server clusters. If there are too many Streaming servers or too ...

Get PostgreSQL High Availability Cookbook - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.