PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it…

Assuming we have a PostgreSQL 10 provider node that has pglogical installed, follow these steps:

1. Register all sequences with this query:

SELECT pglogical.replication_set_add_all_sequences(         set_name := 'default',         schema_names := array_agg(nspname)       )  FROM schema_list;

2. Verify registered sequences with this query:

SELECT s.set_id, ss.set_seqoid  FROM pglogical.replication_set s  JOIN pglogical.replication_set_seq ss USING (set_id);