Horton

Add pg_ls_archive_statusdir function

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: c48101620151f78ee184e5f81766cbac347d9a11
Author: Michael Paquier <michael@paquier.xyz>
Date: 2018-10-09T13:29:09Z
Releases: 12.0 
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

Files

PathChange+/−
doc/src/sgml/func.sgml modified +24 −0
src/backend/catalog/system_views.sql modified +2 −0
src/backend/utils/adt/genfile.c modified +9 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +5 −0

Documentation touched

Discussion