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

VACUUM WARNING: skipping "pg_statistic" --- only table ordatabase owner can vacuum it

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: VACUUM WARNING: skipping "pg_statistic" --- only table ordatabase owner can vacuum it
Date: 2010-01-30 14:59:36
Message-ID: 20100130145936.GA12509@cns.vt.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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

Any ideas how I can clean this up or how I got into this hole?
Vacuum works as superuser.  

Thanks.

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2010-01-30 17:28:37
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Previous:From: Reggie EuserDate: 2010-01-29 22:20:55
Subject: Re: CentOS & PostgreSQL help re: TIME_WAIT

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