Re: user privilages for executing pg_autovacuum?

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: user privilages for executing pg_autovacuum?
Дата
Msg-id 434BC599.60603@zeut.net
обсуждение исходный текст
Ответ на user privilages for executing pg_autovacuum?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
Список pgsql-general
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.



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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Oracle buys Innobase
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Suggest forums software for postgresql?