pgsql: Add slotsync_skip_reason column to pg_replication_slots view. - Mailing list pgsql-committers

From Amit Kapila
Subject pgsql: Add slotsync_skip_reason column to pg_replication_slots view.
Date
Msg-id E1vOr5N-001lsq-2Z@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: pg_buffercache: Add pg_buffercache_mark_dirty{,_relation,_all}()
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Fix pg_isblank()