pgsql: Add conninfo to pg_stat_wal_receiver - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Add conninfo to pg_stat_wal_receiver
Date
Msg-id E1bIMYc-0002L6-6X@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add conninfo to pg_stat_wal_receiver

Commit b1a9bad9e744 introduced a stats view to provide insight into the
running WAL receiver, but neglected to include the connection string in
it, as reported by Michaël Paquier.  This commit fixes that omission.
(Any security-sensitive information is not disclosed).

While at it, close the mild security hole that we were exposing the
password in the connection string in shared memory.  This isn't
user-accessible, but it still looks like a good idea to avoid having the
cleartext password in memory.

Author: Michaël Paquier, Álvaro Herrera
Review by: Vik Fearing

Discussion: https://www.postgresql.org/message-id/CAB7nPqStg4M561obo7ryZ5G+fUydG4v1Ajs1xZT1ujtu+woRag@mail.gmail.com

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9ed551e0a4fdb046d8e5ea779adfd3e184d5dc0d

Modified Files
--------------
doc/src/sgml/monitoring.sgml                       |  8 ++
src/backend/catalog/system_views.sql               |  3 +-
.../libpqwalreceiver/libpqwalreceiver.c            | 52 +++++++++++++
src/backend/replication/walreceiver.c              | 85 +++++++++++++---------
src/include/catalog/catversion.h                   |  2 +-
src/include/catalog/pg_proc.h                      |  2 +-
src/include/replication/walreceiver.h              |  9 ++-
7 files changed, 122 insertions(+), 39 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix match_foreign_keys_to_quals for FKs linking to unused rtable
Next
From: Tom Lane
Date:
Subject: pgsql: Update rules.out to match commit 9ed551e0a.