pgsql: Add more columns to pg_stat_ssl

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add more columns to pg_stat_ssl
Date: 2019-01-31 23:46:30
Message-ID: E1gpM2Q-0008L0-6d@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add more columns to pg_stat_ssl

Add columns client_serial and issuer_dn to pg_stat_ssl. These allow
uniquely identifying the client certificate.

Rename the existing column clientdn to client_dn, to make the naming
more consistent and easier to read.

Discussion: https://www.postgresql.org/message-id/flat/398754d8-6bb5-c5cf-e7b8-22e5f0983caf(at)2ndquadrant(dot)com/

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f60a0e96778854ed0b7fd4737488ba88022e47bd

Modified Files
--------------
doc/src/sgml/monitoring.sgml | 20 ++++++++++++++++++--
src/backend/catalog/system_views.sql | 4 +++-
src/backend/libpq/be-secure-openssl.c | 31 ++++++++++++++++++++++++++++++-
src/backend/postmaster/pgstat.c | 4 +++-
src/backend/utils/adt/pgstatfuncs.c | 22 ++++++++++++++++++----
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 6 +++---
src/include/libpq/libpq-be.h | 4 +++-
src/include/pgstat.h | 16 +++++++++++++---
src/test/regress/expected/rules.out | 10 ++++++----
src/test/ssl/t/001_ssltests.pl | 8 ++++----
11 files changed, 102 insertions(+), 25 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2019-02-01 01:38:26 pgsql: Fix use of dangling pointer in heap_delete() when logging replic
Previous Message Tom Lane 2019-01-31 20:04:04 Re: pgsql: Build src/port files as a library with -fPIC, and use that in li