Re: Allow non-superuser to cancel superuser tasks.

Leung, Anthony <antholeu@amazon.com>

View thread View on postgr.es

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

To: Nathan Bossart <nathandbossart@gmail.com>, Kirill Reshke <reshkekirill@gmail.com>

Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2024-04-01T14:29:29Z

Lists: pgsql-hackers

Attachments

v1-0001-Introduce-pg_signal_autovacuum-role-to-allow-non-sup.patch (application/octet-stream) patch v1-0001

I took the liberty of continuing to work on this after chatting with Nathan.

I've attached the updated patch with some improvements.

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