PostgreSQL 12 High Availability Cookbook - Third Edition

There's more…

When the time comes to synchronize these, we don't actually have to do anything. The subscriber sequences will be updated periodically to reflect updated values. However, should we want to follow a specific schedule, we can actually force a synchronization using a provided function.

Using the following query will manually update all sequences:

SELECT pglogical.synchronize_sequence(set_seqoid)  FROM pglogical.replication_set_seq;

Keep in mind that this function, like many pglogical functions, is asynchronous. It merely injects the command into the pglogical process queue, and will not wait for the sequence to synchronize before returning.