Re: user privilages for executing pg_autovacuum?

Поиск
Список
Период
Сортировка
От codeWarrior
Тема Re: user privilages for executing pg_autovacuum?
Дата
Msg-id dijalt$1h5b$1@news.hub.org
обсуждение исходный текст
Ответ на user privilages for executing pg_autovacuum?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
Список pgsql-general
I run pg_autovacuum as user postgres: owner of the database processes and an
unprivileged user (nologin)




""Zlatko Mati�"" <zlatko.matic1@sb.t-com.hr> wrote in message
news:000001c5ce4f$85121460$52bffea9@zlatkovyfkpgz6...
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



В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Row level locking
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: How to track exceptions in PL/pgSQL