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

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 (view raw or flat)
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

pgsql-admin by date

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

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