Re: non-owner superuser needs to be able to vacuum

"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> A superuser cannot vacuum tables.  The error message is "WARNING:  skipping "thetable"  --- only table or database
ownercan vacuum it" 

Are you *certain* the active role is really a superuser?  I'd say that
that message is sufficient proof that it isn't.

> 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;

Granting privileges to a superuser is 100% pointless...

I wonder whether you are supposing that the superuser property can be
inherited by some other role via role membership grant.  It doesn't work
that way.  You must actually be cover_super here to be superuser.

            regards, tom lane