Re: Allow non-superuser to cancel superuser tasks.

Leung, Anthony <antholeu@amazon.com>

From: "Leung, Anthony" <antholeu@amazon.com>

To: Nathan Bossart <nathandbossart@gmail.com>

Cc: "Andrey M. Borodin" <x4mmm@yandex-team.ru>, Kirill Reshke <reshkekirill@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>, Michael Paquier <michael@paquier.xyz>

Date: 2024-04-05T00:03:05Z

Lists: pgsql-hackers

Attachments

v3-0001-Introduce-pg_signal_autovacuum-role-to-signal-autovacuum-worker.patch (application/octet-stream) patch v3-0001
v3-0002-Add-tap-test-for-pg-signal-autovacuum-role.patch (application/octet-stream) patch v3-0002

Adding tap test for pg_signal_autovacuum using injection points as a separate patch. I also made a minor change on the original patch.

Thanks.

--
Anthony 
Amazon Web Services: https://aws.amazon.com

Commits

Look up backend type in pg_signal_backend() more cheaply.
- 61171a632d10 18.0 landed
Add tap test for pg_signal_autovacuum role
- d2b74882cab8 18.0 landed
Introduce pg_signal_autovacuum_worker.
- ccd38024bc3c 18.0 landed
Add a slot synchronization function.
- ddd5f4f54a02 17.0 cited
Ban role pg_signal_backend from more superuser backend types.
- 3a9b18b30953 17.0 cited