How to do it...

Follow these steps to determine replication resource requirements:

  1. Create a spreadsheet with six columns labeled Source Server, Target Server, Type, DB Name, Table, and Set.
  2. Under the Source Server column, list the role or name of the PostgreSQL server that provides the data.
  1. Under the Target Server column, list the role or name of the PostgreSQL server that receives the data.
  2. Under the Type column, select either Replica to copy the whole database or Logical to copy individual tables.
  3. Under the DB Name column, enter the name of the database where tables reside on the source server. If you are using Replica for Type, enter All here.
  4. Under the Table column, enter All for every table in the listed database, or enter a single ...

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.

Start your free trial