From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | non-owner superuser needs to be able to vacuum |
Date: | 2009-06-03 14:30:13 |
Message-ID: | 482E80323A35A54498B8B70FF2B8798004120C2BAF@azsmsx504.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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!
From | Date | Subject | |
---|---|---|---|
Next Message | Jennifer Trey | 2009-06-03 14:30:55 | Re: High I/O writes activity on disks causing images on browser to lag and not load |
Previous Message | Bill Moran | 2009-06-03 14:13:16 | Re: High I/O writes activity on disks causing images on browser to lag and not load |