Postgres Pro
Downloads
Home   >   mailing lists

Re: New behavior in 7.0 - Mailing list pgsql-general

From Tom Lane
Subject Re: New behavior in 7.0
Date
Msg-id 1897.959697281@sss.pgh.pa.us
Whole thread Raw
In response to New behavior in 7.0  ("Robert J. Sprawls" <sprawlsr@worldnet.att.net>)
List pgsql-general
Tree view 
"Robert J. Sprawls" <sprawlsr@worldnet.att.net> writes:
> NOTICE:  Skipping "pg_type" --- only table owner can VACUUM it
> NOTICE:  Skipping "pg_attribute" --- only table owner can VACUUM it
> [ etc ]

That's what you'll get if you run the vacuum as an unprivileged user.
Generally speaking, database-wide vacuums ought to be done as the
postgres superuser.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Peterson
Date:
Subject: Re: Postgresql usage clip.
Next
From: Thomas Good
Date:
Subject: Re: Postgresql usage clip.