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

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Date: 2010-02-12 17:02:16
Message-ID: 20100212170216.GA1118@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jenaro Centeno Gómez 2010-02-12 17:21:55 Re: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
Previous Message Renato Oliveira 2010-02-12 15:52:52 Re: PG_DUMP backup