non-owner superuser needs to be able to vacuum
От
Gauthier, Dave
Тема
non-owner superuser needs to be able to vacuum
Дата
Msg-id
482E80323A35A54498B8B70FF2B8798004120C2BAF@azsmsx504.amr.corp.intel.com
Список
Дерево обсуждения
non-owner superuser needs to be able to vacuum "Gauthier, Dave" <dave.gauthier@intel.com>
Re: non-owner superuser needs to be able to vacuum Tom Lane <tgl@sss.pgh.pa.us>
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!
В списке pgsql-general по дате отправления
От: Bill Moran
Дата:
От: Jennifer Trey
Дата: