Re: vacuum by non-owner

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Richard Stover <richard(at)ucolick(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum by non-owner
Date: 2003-04-07 22:12:07
Message-ID: m3k7e6kle0.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Stover <richard(at)ucolick(dot)org> writes:

> Do I have to run a small program which is setuid to the owner
> of the tables in order to make it possible for the users to
> VACUUM the tables? Or is there a more elegant way to do this?

Why not run 'vacuumdb' periodically out of 'cron' as the postgres
user?

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2003-04-07 22:24:09 Re: Why no performance boost although I added an index?
Previous Message Jonathan Bartlett 2003-04-07 22:05:43 Re: Why no performance boost although I added an index?