, Tom Lane wrote:
> Tobias Lott writes:
> > There were no crashes of the instance, but some issues with the connected
> > application, resulting in 'could not receive data from client: Connection
> > reset by peer' and 'unexpected EOF on client connection with an
t behind temp tables causing the errors, should I
try to delete these pg_temp tables?
Regards,
Tobias
On Wed, 3 Mar 2021 at 17:10, Tom Lane wrote:
> Tobias Lott writes:
> > Yes that's strange. A lot of pg_XX tables are skipped, but some of these
> > pg_temp schemas caus
21 at 16:15, Tom Lane wrote:
> Laurenz Albe 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 alw
Hi Laurenz,
good to know, thank you very much!
Best regards,
Tobias
On Wed, 3 Mar 2021 at 12:10, Laurenz Albe 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
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
