How to do it...

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

  1. Create a spreadsheet with the following columns: Server Name, Source, Environment, Streaming, Promotion, and Backup.
  2. Consider using an external tool if any of these are true:
    • For Environment, use Production or Disaster Recovery
    • Specify True or False for Streaming if the server is a streaming provider or recipient
    • Mark the Promotion column as True or False if the server can be promoted to be the master copy for the whole constellation of servers
    • Indicate True or False for Backup if the server is used for backups
  3. Create a row for each server indicating its Server Name and the Source of its data.
  1. For each row, set the corresponding attribute ...

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.