I run pg_autovacuum as user postgres: owner of the database processes and an unprivileged user (nologin) ""Zlatko Matiæ"" <zlatko.matic1@xxxxxxxxxxx> wrote in message news:000001c5ce4f$85121460$52bffea9@xxxxxxxxxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
