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

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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(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-30 17:28:37
Message-ID: dcc563d11001300928s1ab6c725yd678a1937092a250@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, Jan 30, 2010 at 7:59 AM, Ray Stell <stellr(at)cns(dot)vt(dot)edu> 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
>
> Any ideas how I can clean this up or how I got into this hole?
> Vacuum works as superuser.

Make yourself the owner of the database? (i.e. alter database ...)

In response to

Responses

pgsql-admin by date

Next:From: Ray StellDate: 2010-01-30 22:04:37
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only tableor database owner can vacuum it
Previous:From: Ray StellDate: 2010-01-30 14:59:36
Subject: VACUUM WARNING: skipping "pg_statistic" --- only table ordatabase owner can vacuum it

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