pgsql: Enhance pg_stat_wal_receiver view to display host and port of se

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Enhance pg_stat_wal_receiver view to display host and port of se
Date: 2018-03-30 23:03:53
Message-ID: E1f233p-0002vt-PH@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2018-03-31 00:09:41 pgsql: Combine options for RangeVarGetRelidExtended() into a flags argu
Previous Message Tom Lane 2018-03-30 22:15:30 pgsql: Fix bogus provolatile/proparallel markings on a few built-in fun