Postgres Pro
Downloads
Home   >   mailing lists

VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it - Mailing list pgsql-admin

From Ray Stell
Subject VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Date
Msg-id 20100130145936.GA12509@cns.vt.edu
Whole thread Raw
Responses Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: "Reggie Euser"
Date:
Subject: Re: CentOS & PostgreSQL help re: TIME_WAIT
Next
From: Scott Marlowe
Date:
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it