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-04T20:34:18Z

Lists: pgsql-hackers

Attachments

v2-0001-Introduce-pg_signal_autovacuum-role-to-cancel-or-termiante-autovacuum-worker.patch (application/octet-stream) patch v2-0001

I made some updates based on the feedbacks in v2. This patch only contains the code change for allowing the signaling to av worker with pg_signal_autovacuum. I will send a separate patch for the tap test shortly.

Thanks

--
Anthony Leung
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