Re: CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others
Дата
Msg-id 19228.1207548151@sss.pgh.pa.us
обсуждение исходный текст
Ответ на CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others  (Gabriel Ramirez <gabrieloacapulco@gmail.com>)
Список pgsql-bugs
Gabriel Ramirez <gabrieloacapulco@gmail.com> writes:
>   Tip:  It is good practice to create a role that has the CREATEDB
> and CREATEROLE privileges, but is not a superuser, and then use this
> role for all routine management of databases and roles. This approach
> avoids the dangers of operating as a superuser for tasks that do not
> really require it.

Nowhere does that say, or even suggest, that database-wide vacuuming is
a task that doesn't require superuser.

            regards, tom lane

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

Предыдущее
От: Gabriel Ramirez
Дата:
Сообщение: CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #3983: pgxs files still missing in win32 install (8.3.1)