I run pg_autovacuum as user postgres: owner of the database processes and an unprivileged user (nologin)
""Zlatko Matiæ"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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
