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

From Ray Stell
Subject Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Date
Msg-id 20100212170216.GA1118@cns.vt.edu
Whole thread Raw
In response to Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
On Tue, Feb 09, 2010 at 05:39:52PM -0500, Ray Stell wrote:
> On Sat, Jan 30, 2010 at 09:59:36AM -0500, Ray Stell wrote:
>
> Is autovacuum handing all users off to vacuum all rels?  Even those
> it does not own?  Perhaps "admin" an unfortunate usename choice?


doh...the light comes on.

reading through postinit.c and others makes it clear autovacuum is not the source
of the vacuum.  No doubt the app, Cisco Fabric Manager Server, is doing something
stupid.  Yep:

/var/local/cisco_mds9000
# strings ./jboss/server/default/deploy/dcm.ear/dcm.jar/com/cisco/dcbu/sm/server/db/PostgresWrapper.class | grep -i
vacuum
 vacuum_analyze
vacuum analyze
 vacuum_analyze failed:

2.     Irrelephant
Anything that is unrelated to an elephant.
http://www.urbandictionary.com/define.php?term=irrelephant

pgsql-admin by date:

Previous
From: Renato Oliveira
Date:
Subject: Re: PG_DUMP backup
Next
From: dx k9
Date:
Subject: Postgresql & PAM & active directory