On Thu, 14 Dec 2023 at 02:13, Imseih (AWS), Sami <sims...@amazon.com> wrote: > > Hi, > > > > A recent case in the field in which a database session_authorization is > > altered to a non-superuser, non-owner of tables via alter database .. set > session_authorization .. > > caused autovacuum to skip tables. > > > > The issue was discovered on 13.10, and the logs show such messages: > > > > warning: skipping "table1" --- only table or database owner can vacuum it > > > > In HEAD, I can repro, but the message is now a bit different due to [1]. > > > > WARNING: permission denied to vacuum "table1”, skipping it > > > > It seems to me we should force an autovacuum worker to set the session userid > to > > a superuser. > > > > Attached is a repro and a patch which sets the session user to the BOOTSTRAP > superuser > > at the start of the autovac worker.
Since there is not much interest on this patch, I have changed the status with "Returned with Feedback". Feel free to propose a stronger use case for the patch and add an entry for the same. Regards, Vignesh
