Hi Laurenz, good to know, thank you very much!
Best regards, Tobias On Wed, 3 Mar 2021 at 12:10, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > 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 > > -- Tobias Lott Technical Consultant Region South West +49 151 23649035 <+49+151+23649035> tobias.l...@devoteam.com [image: Banner EVP Intelligence] [image: Devoteam at Linkedin] <https://www.linkedin.com/company/devoteam> [image: Devoteam at Youtube] <https://www.youtube.com/watch?v=Lrk4lQJ82bI&t=3s> [image: Devoteam at Twitter] <https://twitter.com/devoteam>
