From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it |
Date: | 2010-01-31 18:44:10 |
Message-ID: | 20100131184410.GA6991@cns.vt.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sat, Jan 30, 2010 at 07:18:52PM -0700, Scott Marlowe wrote:
> On Sat, Jan 30, 2010 at 7:00 PM, Ray Stell <stellr(at)cns(dot)vt(dot)edu> wrote:
> > On Sat, Jan 30, 2010 at 10:35:27PM -0300, Alvaro Herrera wrote:
> >> Ray Stell wrote:
> >> > Running 8.2.15 on RHEL4 the log reports this from autovacuum along with
> >> > other pg_ tables:
> >> >
> >> > VACUUM WARNING: ?skipping "pg_database" --- only table or database owner can vacuum it
> >>
> >> Huh, that's pretty weird ... autovacuum is supposed to connect as
> >> superuser internally. ?Did you do something funny to the system role
> >> (typically called "postgres")?
> >
> >
> > agreed. ?If I did, I don't know what it was. I suppose I'm reduced
> > to creating a new cluster and restoring the apps into it, unless
> > somebody can suggest an audit method that would uncover the injury.
>
> Whoa, don't burn down the village just yet.
no worries, fairly small cluster, but if somebody knows
how to weed this out that would be a great help.
> What does \du postgres say?
I used "-U pgadmin" on my initdb, so I don't have postgres user:
template1=# \du
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
-----------+-----------+-------------+-----------+-------------+-----------
admin | no | no | no | no limit |
pgadmin | yes | yes | yes | no limit |
(2 rows)
but you see she does own the farm:
template1=# \l
List of databases
Name | Owner | Encoding
-----------+---------+----------
fms | pgadmin | UTF8
postgres | pgadmin | UTF8
template0 | pgadmin | UTF8
template1 | pgadmin | UTF8
(4 rows)
Thanks for your time.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Corner | 2010-02-01 16:02:35 | Using pg_migrator to upgrade 8.3->8.4 |
Previous Message | Scott Marlowe | 2010-01-31 02:18:52 | Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it |