Re: user privilages for executing pg_autovacuum?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: user privilages for executing pg_autovacuum?
Date: 2005-10-11 14:00:57
Message-ID: 434BC599.60603@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zlatko Matić wrote:
> For pg_dump minimum privilages is to have select right on tables.
> For vacuumdb, one must be owner of tables or a superuser.
>
> What are minimum rights for user that is trying to execute pg_autovacuum ?

Not sure exactly, you need to have permission to vacuum every table in
the database including system tables.

>
> How can I monitor vacuuming by pg_autovacuum ?

It logs all its activity if you set the debug option to an appropriate
level. Try -d1 or -d2.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2005-10-11 14:07:45 Re: Suggest forums software for postgresql?
Previous Message Robert Treat 2005-10-11 13:48:57 Re: Oracle buys Innobase