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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: 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 01:35:27
Message-ID: 20100131013526.GA3337@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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")?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2010-01-31 02:00:01 Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Previous Message Ray Stell 2010-01-30 22:04:37 Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it