PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

After the last few extensions, using pglogical is almost refreshingly easy. As usual, we start by copying the pgbench table definitions from the origin node to the subscriber. Once that is done, the provider node has only one job: to create a subscription set.

The subscription set we create is named pgbench to fit the theme of copying multiple pgbench tables. When defining a replication set with the create_replication_set function, we actually have a few options that the other replication systems did not offer. We elected to only replicate INSERT and UPDATE statements in this example. In such a scenario, the origin server can delete records from the table or truncate it entirely, and the records on the subscriber will remain. ...