Re: Autovacuum Issues? - Mailing list pgsql-general

From Tom Lane
Subject Re: Autovacuum Issues?
Date
Msg-id 19544.1296497276@sss.pgh.pa.us
Whole thread Raw
In response to Autovacuum Issues?  (Kenneth Buckler <kenneth.buckler@gmail.com>)
Responses Re: Autovacuum Issues?
List pgsql-general
Kenneth Buckler <kenneth.buckler@gmail.com> writes:
> Does autovacuum automatically use the 'postgres' role?

It automatically uses the bootstrap superuser role.

> If so, how can I change what role autovacuum uses?

You can't.

> One of the security requirements
> I've been required to implement removes superuser privileges from
> postgres and assigns those privileges to a different role.

You can't mess around with the bootstrap superuser.  If you like, you
can cause it to be named something other than "postgres" --- just run
initdb as some other operating system user name.  (I think it would also
work to do ALTER USER RENAME after the fact, but haven't really
experimented with the consequences of that.)  But otherwise, this
"security requirement" seems pretty air-headed.  You have to have a
superuser.

            regards, tom lane

pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: Adding more space, and a vacuum question.
Next
From: Nicos Panayides
Date:
Subject: Weird performance issue with custom function with a for loop.