pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Amit Kapila <akapila@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add slotsync_skip_reason column to pg_replication_slots view.
Date: Fri, 28 Nov 2025 05:32:02 +0000
Message-ID: <E1vOr5N-001lsq-2Z@gemulon.postgresql.org> (raw)

Add slotsync_skip_reason column to pg_replication_slots view.

Introduce a new column, slotsync_skip_reason, in the pg_replication_slots
view. This column records the reason why the last slot synchronization was
skipped. It is primarily relevant for logical replication slots on standby
servers where the 'synced' field is true. The value is NULL when
synchronization succeeds.

Author: Shlok Kyal <shlok.kyal.oss@gmail.com>
Reviewed-by: shveta malik <shveta.malik@gmail.com>
Reviewed-by: Hayato Kuroda <kuroda.hayato@fujitsu.com>
Reviewed-by: Ashutosh Sharma <ashu.coek88@gmail.com>
Reviewed-by: Hou Zhijie <houzj.fnst@fujitsu.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CAE9k0PkhfKrTEAsGz4DjOhEj1nQ+hbQVfvWUxNacD38ibW3a1g@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e68b6adad96d414fdf24e072fdb1d41fb4b8f0b7

Modified Files
--------------
doc/src/sgml/monitoring.sgml                       |  4 +-
doc/src/sgml/system-views.sgml                     | 43 ++++++++++++++++++++++
src/backend/catalog/system_views.sql               |  3 +-
src/backend/replication/logical/slotsync.c         | 43 +++++++++++++++++++---
src/backend/replication/slot.c                     |  1 +
src/backend/replication/slotfuncs.c                | 18 ++++++++-
src/backend/utils/activity/pgstat_replslot.c       |  4 +-
src/include/catalog/catversion.h                   |  2 +-
src/include/catalog/pg_proc.dat                    |  6 +--
src/include/replication/slot.h                     | 30 +++++++++++++++
.../recovery/t/040_standby_failover_slots_sync.pl  |  6 +++
src/test/regress/expected/rules.out                |  5 ++-
src/tools/pgindent/typedefs.list                   |  1 +
13 files changed, 149 insertions(+), 17 deletions(-)



Message-ID: <E1vOr5N-001lsq-2Z@gemulon.postgresql.org>
Permalink:  ../E1vOr5N-001lsq-2Z@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1vOr5N-001lsq-2Z@gemulon.postgresql.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: akapila@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Add slotsync_skip_reason column to pg_replication_slots view.
  In-Reply-To: <E1vOr5N-001lsq-2Z@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox