pgsql: Enhance pg_stat_wal_receiver view to display host and port ofse - Mailing list pgsql-committers

From Fujii Masao
Subject pgsql: Enhance pg_stat_wal_receiver view to display host and port ofse
Date
Msg-id E1f233p-0002vt-PH@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Enhance pg_stat_wal_receiver view to display host and port of sender server.

Previously there was no way in the standby side to find out the host and port
of the sender server that the walreceiver was currently connected to when
multiple hosts and ports were specified in primary_conninfo. For that purpose,
this patch adds sender_host and sender_port columns into pg_stat_wal_receiver
view. They report the host and port that the active replication connection
currently uses.

Bump catalog version.

Author: Haribabu Kommi
Reviewed-by: Michael Paquier and me

Discussion: https://postgr.es/m/CAJrrPGcV_aq8=cdqkFhVDJKEnDQ70yRTTdY9RODzMnXNrCz2Ow@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9a895462d940c0694042059f90e5f63a0a517ded

Modified Files
--------------
doc/src/sgml/monitoring.sgml                       | 19 +++++++++++++
src/backend/catalog/system_views.sql               |  2 ++
.../libpqwalreceiver/libpqwalreceiver.c            | 26 ++++++++++++++++++
src/backend/replication/walreceiver.c              | 32 ++++++++++++++++++++--
src/include/catalog/catversion.h                   |  2 +-
src/include/catalog/pg_proc.h                      |  2 +-
src/include/replication/walreceiver.h              | 13 +++++++++
src/test/regress/expected/rules.out                |  4 ++-
8 files changed, 94 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix bogus provolatile/proparallel markings on a few built-infun
Next
From: Andres Freund
Date:
Subject: pgsql: Combine options for RangeVarGetRelidExtended() into a flagsargu