Skip site navigation (1) Skip section navigation (2)

Re: VACUUM WARNING: skipping "pg_statistic" --- only tableor database owner can vacuum it

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 tableor database owner can vacuum it
Date: 2010-01-31 18:44:10
Message-ID: 20100131184410.GA6991@cns.vt.edu (view raw or flat)
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.


In response to

pgsql-admin by date

Next:From: Mark CornerDate: 2010-02-01 16:02:35
Subject: Using pg_migrator to upgrade 8.3->8.4
Previous:From: Scott MarloweDate: 2010-01-31 02:18:52
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group