Re: prevent non-superuser terminate bgworker running as superuser

2023-10-19 Thread Jelte Fennema
This seems like it should even be considered a security honestly. On Thu, 19 Oct 2023, 19:49 Hemanth Sandrana, wrote: > Hi All, > > Currently, BackgroundWorker connected to a database by calling > BackgroundWorkerInitializeConnection with username as NULL can be > terminated by non-superuser wit

prevent non-superuser terminate bgworker running as superuser

2023-10-19 Thread Hemanth Sandrana
Hi All, Currently, BackgroundWorker connected to a database by calling BackgroundWorkerInitializeConnection with username as NULL can be terminated by non-superuser with pg_signal_backend privilege. When the username is NULL the bgworker process runs as superuser (which is expected as per the docu