non-owner superuser needs to be able to vacuum - Mailing list pgsql-general

Hi:

A superuser cannot vacuum tables.  The error message is “WARNING:  skipping “thetable”  --- only table or database owner can vacuum it”

The superuser was defined like this...

create role cover_super SUPERUSER LOGIN;

grant all            on database cover to cover_super;

grant all privileges on map_src_info   to cover_super;

grant all privileges on insts          to cover_super;

grant all privileges on temp_pins      to cover_super;

The error message seems to indicate that defining a superuser which is not the table owner to vacuum is futile (“only table or database owner can...”).

Is there a way to vacuum with a non table owner ?

Thanks for any help!