pgsql: Add pg_ls_archive_statusdir function

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add pg_ls_archive_statusdir function
Date: 2018-10-09 13:38:25
Message-ID: E1g9sDR-0006ul-9O@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add pg_ls_archive_statusdir function

This function lists the contents of the WAL archive status directory,
and is intended to be used by monitoring tools. Unlike pg_ls_dir(),
access to it can be granted to non-superusers so that those monitoring
tools can observe the principle of least privilege. Access is also
given by default to members of pg_monitor.

Author: Christoph Moench-Tegeder
Reviewed-by: Aya Iwata
Discussion: https://postgr.es/m/20180930205920.GA64534@elch.exwg.net

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/func.sgml | 24 ++++++++++++++++++++++++
src/backend/catalog/system_views.sql | 2 ++
src/backend/utils/adt/genfile.c | 9 +++++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 5 +++++
5 files changed, 41 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-10-09 15:10:14 pgsql: Select appropriate PG_PRINTF_ATTRIBUTE for recent NetBSD.
Previous Message Kyotaro HORIGUCHI 2018-10-09 09:15:36 Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru