pgsql: Doc: Add documentation for sequence synchronization.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: Add documentation for sequence synchronization.
Date: 2025-11-12 08:48:14
Message-ID: E1vJ6WU-006Coz-2U@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)gmail(dot)com>
Reviewed-by: Peter Smith <smithpb2250(at)gmail(dot)com>
Reviewed-by: shveta malik <shveta(dot)malik(at)gmail(dot)com>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Reviewed-by: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAA4eK1LC+KJiAkSrpE_NwvNdidw9F2os7GERUeSxSKv71gXysQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/55cefadde874e52b57f7b3c2232744e331f9d6bb

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 2 +-
doc/src/sgml/config.sgml | 16 +-
doc/src/sgml/func/func-sequence.sgml | 28 +++
doc/src/sgml/logical-replication.sgml | 294 +++++++++++++++++++++++++++---
doc/src/sgml/monitoring.sgml | 5 +-
doc/src/sgml/ref/alter_subscription.sgml | 15 ++
doc/src/sgml/ref/create_subscription.sgml | 31 +++-
7 files changed, 350 insertions(+), 41 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2025-11-12 11:13:17 pgsql: Fix pg_upgrade around multixid and mxoff wraparound
Previous Message Michael Paquier 2025-11-12 07:53:33 pgsql: Move code specific to pg_dependencies to new file