Add pg_ls_summariesdir().
authorNathan Bossart
Fri, 11 Oct 2024 16:02:09 +0000 (11:02 -0500)
committerNathan Bossart
Fri, 11 Oct 2024 16:02:09 +0000 (11:02 -0500)
commit4e1fad37872e49a711adad5d9870516e5c71a375
treeb22f685d15c9a28aa22328f769d6b5c5bef61319
parentadd77755ce851fae2f72be4b9c56a606f9362895
Add pg_ls_summariesdir().

This function returns the name, size, and last modification time of
each regular file in pg_wal/summaries.  This allows administrators
to grant privileges to view the contents of this directory without
granting privileges on pg_ls_dir(), which allows listing the
contents of many other directories.  This commit also gives the
pg_monitor predefined role EXECUTE privileges on the new
pg_ls_summariesdir() function.

Bumps catversion.

Author: Yushi Ogiwara
Reviewed-by: Michael Paquier, Fujii Masao
Discussion: https://postgr.es/m/a0a3af15a9b9daa107739eb45aa9a9bc%40oss.nttdata.com
doc/src/sgml/func.sgml
src/backend/catalog/system_functions.sql
src/backend/utils/adt/genfile.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/misc_functions.out
src/test/regress/sql/misc_functions.sql