| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Tobias Lott <tobias(dot)lott(at)devoteam(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: permission denied for pg_temp_XX when vacuuming |
| Date: | 2021-03-03 11:10:26 |
| Message-ID: | aa0752c327533fb9b2970618cdf2f28a800cdaee.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2021-03-03 at 09:58 +0100, Tobias Lott wrote:
> I have a database in a PostgreSQL 12 instance.
> When running vacuumdb -z on the database with the user set as owner of the DB, I sometimes, not always, get errors such as:
> error: vacuuming of table "pg_temp_93.vacuum_l" in database "10050" failed: ERROR: permission denied for schema pg_temp_93
> The specific number of the pg_temp schema (pg_temp_XX) is always changing. What could be the reason for this error?
Those are schemas for temporary tables, which you cannot VACUUM outside the
session that created them, so you can safely ignore these errors.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathias Zarick | 2021-03-03 11:23:18 | problems with my community account on www.postgresql.org |
| Previous Message | Tiemen Ruiten | 2021-03-03 10:32:22 | Re: self-made certs not quite right |