[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] New behavior in 7.0
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2000-05-30 14:34:41
[Download RAW message or body]

"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

[prev in list] [next in list] [prev in thread] [next in thread]