While reviewing another patch I referred to the information of "29.7.
Replicating Sequences #" [1] which says:
"use CREATE SUBSCRIPTION to initially synchronize the published sequences."
AFAIK, that is not entirely correct -- synchronisation of sequences
happens only when the "copy_data" option is true. Although copy_data
default is true, the original text was misleading. Anyway, it misled
me.
PSA a patch to clarify that "copy_data = true" is needed.
======
[1] https://www.postgresql.org/docs/19/logical-replication-sequences.html
Kind Regards,
Peter Smith.
Fujitsu Australia
