Re: user privilages for executing pg_autovacuum? - Mailing list pgsql-general

From codeWarrior
Subject Re: user privilages for executing pg_autovacuum?
Date
Msg-id dijalt$1h5b$1@news.hub.org
Whole thread Raw
In response to user privilages for executing pg_autovacuum?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
List pgsql-general
I run pg_autovacuum as user postgres: owner of the database processes and an
unprivileged user (nologin)




""Zlatko Mati�"" <zlatko.matic1@sb.t-com.hr> wrote in message
news:000001c5ce4f$85121460$52bffea9@zlatkovyfkpgz6...
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



pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Row level locking
Next
From: Michael Fuhr
Date:
Subject: Re: How to track exceptions in PL/pgSQL