Yes that's strange. A lot of pg_XX tables are skipped, but some of these pg_temp schemas cause errors.
Could it be connected to a migration of the database (from an instance running PostgreSQL 9.6 to an instance running PostgreSQL 12) done a few weeks ago?
Regards,
Tobias
On Wed, 3 Mar 2021 at 16:15, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Laurenz Albe <laurenz.albe@xxxxxxxxxxx> writes:
> 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.
Indeed, but I'm wondering why vacuumdb isn't skipping them
automatically. Something fishy seems to be happening there.
regards, tom lane
