Add pg_ls_tmpdir function
Michael Paquier <michael@paquier.xyz>
Add pg_ls_tmpdir function This lists the contents of a temporary directory associated to a given tablespace, useful to get information about on-disk consumption caused by temporary files used by a session query. By default, pg_default is scanned, and a tablespace can be specified as argument. This function is intended to be used by monitoring tools, and, unlike pg_ls_dir(), access to them 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: Nathan Bossart Reviewed-by: Laurenz Albe Discussion: https://postgr.es/m/92F458A2-6459-44B8-A7F2-2ADD3225046A@amazon.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +27 −0 |
| src/backend/catalog/system_views.sql | modified | +4 −0 |
| src/backend/utils/adt/genfile.c | modified | +55 −7 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.dat | modified | +10 −0 |
Documentation touched
Discussion
- pg_ls_tmpdir() 14 messages · 2018-09-12 → 2018-10-05