I run pg_autovacuum as user postgres: owner of the database processes and an
unprivileged user (nologin)
""Zlatko Mati"" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> wrote in message
news:000001c5ce4f$85121460$52bffea9(at)zlatkovyfkpgz6(dot)(dot)(dot)
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