Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: New behavior in 7.0
Date
Msg-id Pine.GSO.4.02A.10005301305410.10362-100000@Leopard.DoCS.UU.SE
Whole thread Raw
In response to New behavior in 7.0  ("Robert J. Sprawls" <sprawlsr@worldnet.att.net>)
List pgsql-general
Tree view 
On Tue, 30 May 2000, Robert J. Sprawls wrote:

>     I've worked with 6.5.3 and few other older versions. I've never
> had this happen before. Can some one give some explaination?

> bash-2.03$ psql -d sprawlsr -c "vacuum"
> NOTICE:  Skipping "pg_type" --- only table owner can VACUUM it
[more of that]
> NOTICE:  Skipping "pg_tables" --- only table owner can VACUUM it
> VACUUM

Uh, only table owners can vacuum tables, so you have to be the superuser
to run a complete vacuum on a database. Try psql's -U option to set the
user.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-general by date:

Previous
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: Is PostgreSQL multi-threaded?
Next
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: lots of large objects and toast