Horton

Introduce pg_signal_autovacuum_worker.

Nathan Bossart <nathan@postgresql.org>

View on postgr.es
Commit: ccd38024bc3c61e62af2097d408a670661713e68
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2024-07-09T18:03:40Z
Releases: 18.0 
Introduce pg_signal_autovacuum_worker.

Since commit 3a9b18b309, roles with privileges of pg_signal_backend
cannot signal autovacuum workers.  Many users treated the ability
to signal autovacuum workers as a feature instead of a bug, so we
are reintroducing it via a new predefined role.  Having privileges
of this new role, named pg_signal_autovacuum_worker, only permits
signaling autovacuum workers.  It does not permit signaling other
types of superuser backends.

Bumps catversion.

Author: Kirill Reshke
Reviewed-by: Anthony Leung, Michael Paquier, Andrey Borodin
Discussion: https://postgr.es/m/CALdSSPhC4GGmbnugHfB9G0%3DfAxjCSug_-rmL9oUh0LTxsyBfsg%40mail.gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +8 −0
doc/src/sgml/user-manag.sgml modified +5 −0
src/backend/storage/ipc/signalfuncs.c modified +37 −9
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_authid.dat modified +5 −0

Documentation touched

Discussion