Search Postgresql Archives

Re: permission denied for pg_temp_XX when vacuuming

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Laurenz,

good to know, thank you very much!

Best regards,
Tobias

On Wed, 3 Mar 2021 at 12:10, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
tobias.lott@xxxxxxxxxxxx
Banner EVP Intelligence
Devoteam at Linkedin
Devoteam at Youtube
Devoteam at Twitter

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux