Doc: Add documentation for sequence synchronization.
Amit Kapila <akapila@postgresql.org>
Doc: Add documentation for sequence synchronization. Add documentation describing sequence synchronization support in logical replication. It explains how sequence changes are synchronized from the publisher to the subscriber, the configuration requirements, and provide examples illustrating setup and usage. Additionally, document the pg_get_sequence_data() function, which allows users to query sequence details on the publisher to determine when to refresh corresponding sequences on the subscriber. Author: Vignesh C <vignesh21@gmail.com> Reviewed-by: Peter Smith <smithpb2250@gmail.com> Reviewed-by: shveta malik <shveta.malik@gmail.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Discussion: https://postgr.es/m/CAA4eK1LC+KJiAkSrpE_NwvNdidw9F2os7GERUeSxSKv71gXysQ@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +1 −1 |
| doc/src/sgml/config.sgml | modified | +10 −6 |
| doc/src/sgml/func/func-sequence.sgml | modified | +28 −0 |
| doc/src/sgml/logical-replication.sgml | modified | +272 −22 |
| doc/src/sgml/monitoring.sgml | modified | +3 −2 |
| doc/src/sgml/ref/alter_subscription.sgml | modified | +15 −0 |
| doc/src/sgml/ref/create_subscription.sgml | modified | +21 −10 |
Discussion
- Logical Replication of sequences 507 messages · 2024-06-04 → 2026-01-20