Re: Autovacuum in the backend - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Autovacuum in the backend
Date
Msg-id 10971.1118899936@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum in the backend  (Alvaro Herrera <alvherre@surnet.cl>)
Responses Re: Autovacuum in the backend
List pgsql-hackers
Alvaro Herrera <alvherre@surnet.cl> writes:
> A question for interested parties.  I'm thinking in handling the
> user/password issue by reading the flat files (the copies of pg_shadow,
> pg_database, etc).

Er, what "user/password issue"?  Context please.

> The only thing that I'd need to modify is add the datdba field to
> pg_database, so we can figure out an appropiate user for vacuuming each
> database.

The datdba is not necessarily a superuser, and therefore is absolutely
not the right answer for any question related to autovacuum.  But in
any case, I would expect that an integrated-into-the-backend autovac
implementation would be operating at a level below any permission checks
--- so this question shouldn't be relevant anyway.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Autovacuum in the backend
Next
From: Gavin Sherry
Date:
Subject: Re: Autovacuum in the backend