From: Andrus <kobruleht2@hot.ee>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Huge number of pg_temp and pg_toast_temp schemas
Date: Fri, 10 Apr 2020 19:32:37 +0300
Message-ID: <6F99845517EB402E9269BD6767CCE53C@dell2> (raw)
Hi!
Postgres 12 database contains huge number of pg_temp and pg_toast_temp schemas named
pg_temp_1 .. pg_temp_126
and
pg_toast_temp_1 .. pg_toast_temp_126
There are total 2 * 126 = 252 unnessecary schemas in one database.
Those schemas seems not contain any objects.
Other databases in cluster similar schemas but in smaller amount.
How to delete them automatically and prevent appear in future?
Cluster stopped since disk decomes full and streaming async replication is used. Maybe one of those or some other factor created or
continues to create those schemas. Postgres 12.2 in Debian 10 is used.
Andrus.
Attachments:skeem.PNG (image/png, 41.9K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: kobruleht2@hot.ee
Subject: Re: Huge number of pg_temp and pg_toast_temp schemas
In-Reply-To: <6F99845517EB402E9269BD6767CCE53C@dell2>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox