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.
