Re: vacuumdb: permission denied for schema "pg_temp_7" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: vacuumdb: permission denied for schema "pg_temp_7"
Date
Msg-id 2603142.1726873660@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuumdb: permission denied for schema "pg_temp_7"  (Noah Misch <noah@leadboat.com>)
Responses Re: vacuumdb: permission denied for schema "pg_temp_7"
List pgsql-bugs
Noah Misch <noah@leadboat.com> writes:
>>>> That helps, but we'd probably want to do something more general about vacuumdb
>>>> and schema USAGE permission.

I agree a more general fix is needed, but I think excluding temp
tables as suggested is a good idea for performance, independently of
permissions concerns.  vacuum_rel() will ignore requests to vacuum
such tables, which is why we've not heard complaints before, but
nonetheless we're wasting server round trips by issuing those
requests.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Noah Misch
Date:
Subject: Re: vacuumdb: permission denied for schema "pg_temp_7"
Next
From: Tomas Vondra
Date:
Subject: Re: BUG #18569: Memory leak in Postgres Enterprise server