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

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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
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 02:18:52
Message-ID: dcc563d11001301818q750b97a7wa98f883c002dc4c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.

What does \du postgres say?

In response to

Responses

pgsql-admin by date

Next:From: Ray StellDate: 2010-01-31 18:44:10
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only tableor database owner can vacuum it
Previous:From: Ray StellDate: 2010-01-31 02:00:01
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- onlytable or database owner can vacuum it

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