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	January 30, 2010 10:59:50
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 Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
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:

From: "Reggie Euser"
Date: 29 January 2010, 18:21:14
Subject: Re: CentOS & PostgreSQL help re: TIME_WAIT

From: Scott Marlowe
Date: 30 January 2010, 13:28:51
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it

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

Previous

Next