user privilages for executing pg_autovacuum?

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: user privilages for executing pg_autovacuum?
Date: 2005-10-10 20:05:26
Message-ID: 000001c5ce4f$85121460$52bffea9@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

How can I monitor vacuuming by pg_autovacuum ?

Thanks,

Zlatko

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Travis Brady 2005-10-10 20:16:00 Cluster/redundancy question
Previous Message Michael Fuhr 2005-10-10 19:50:19 Re: error in SELECT from store procedure