Allow GRANT on pg_log_backend_memory_contexts().
Jeff Davis <jdavis@postgresql.org>
Allow GRANT on pg_log_backend_memory_contexts(). Remove superuser check, allowing any user granted permissions on pg_log_backend_memory_contexts() to log the memory contexts of any backend. Note that this could allow a privileged non-superuser to log the memory contexts of a superuser backend, but as discussed, that does not seem to be a problem. Reviewed-by: Nathan Bossart, Bharath Rupireddy, Michael Paquier, Kyotaro Horiguchi, Andres Freund Discussion: https://postgr.es/m/e5cf6684d17c8d1ef4904ae248605ccd6da03e72.camel@j-davis.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +0 −1 |
| src/backend/catalog/system_functions.sql | modified | +2 −0 |
| src/backend/utils/adt/mcxtfuncs.c | modified | +4 −10 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/test/regress/expected/misc_functions.out | modified | +31 −2 |
| src/test/regress/sql/misc_functions.sql | modified | +24 −2 |
Documentation touched
Discussion
- Allow pg_signal_backend members to use pg_log_backend_memory_stats(). 23 messages · 2021-10-23 → 2021-10-26