Re: user privilages for executing pg_autovacuum?

From: "codeWarrior" <gpatnude(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: user privilages for executing pg_autovacuum?
Date: 2005-10-12 15:39:09
Message-ID: dijalt$1h5b$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-10-12 16:11:32 Re: How to track exceptions in PL/pgSQL
Previous Message Michael Fuhr 2005-10-12 15:29:42 Re: Row level locking