Gabriel Ramirez <gabrieloacapulco(at)gmail(dot)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
In response to
pgsql-bugs by date
|Next:||From: Magnus Hagander||Date: 2008-04-07 06:54:29|
|Subject: Re: BUG #3983: pgxs files still missing in win32 install
|Previous:||From: Gabriel Ramirez||Date: 2008-04-07 05:55:53|
|Subject: CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others|