permission denied for pg_temp_XX when vacuuming

From: Tobias Lott <tobias(dot)lott(at)devoteam(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: permission denied for pg_temp_XX when vacuuming
Date: 2021-03-03 08:58:33
Message-ID: CANCOamzvWnviA+_ZPAUUYV=kW9_QOLNSJ7RzE4APYe-_DhtJfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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?

Thanks and best regards,
Tobias

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tiemen Ruiten 2021-03-03 10:32:22 Re: self-made certs not quite right
Previous Message Alexander Farber 2021-03-03 08:08:29 Re: Localizing stored functions by replacing placeholders in their body