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.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
