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
v1-0001-DOCS-clarify-copy_data-is-needed-to-synchronise-s.patch
Description: Binary data
