Обсуждение: pgsql: Enhance pg_stat_wal_receiver view to display host and port ofse
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(-)