Re: CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others - Mailing list pgsql-bugs

From Tom Lane
Subject Re: CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others
Date
Msg-id 19228.1207548151@sss.pgh.pa.us
Whole thread Raw
In response to CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others  (Gabriel Ramirez <gabrieloacapulco@gmail.com>)
List 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 by date:

Previous
From: Gabriel Ramirez
Date:
Subject: CREATEDB and CREATEROLE privileges cannot vacuum pg_authid and others
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #3983: pgxs files still missing in win32 install (8.3.1)