Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Date
Msg-id 20100131013526.GA3337@alvh.no-ip.org
Whole thread Raw
In response to VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it  (Ray Stell <stellr@cns.vt.edu>)
Responses 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 
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

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Next
From: Ray Stell
Date:
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it