Postgres Pro
Downloads
Home   >   mailing lists

autovacuum: found orphan temp - Mailing list pgsql-admin

From francescoboccacci@libero.it
Subject autovacuum: found orphan temp
Date
Msg-id 25486882.2125931342712330597.JavaMail.defaultUser@defaultHost
Whole thread Raw
List pgsql-admin
Tree view 
Hi all,
in postgresql log file i found a lots of rows like:

autovacuum: found orphan temp table "pg_temp_32"."test11" in database "Test"

I tried to select this table:

select * from "pg_temp_32"."test11"

but i received the follow error:

ERROR:  could not open file "base/16385/t32_13288115": No such file or
directory

How i can solve this problem?

Thanks


Francesco

pgsql-admin by date:

Previous
From: Ali Pouya
Date:
Subject: Measurin the lag between a master and a replica
Next
From: Sergey Konoplev
Date:
Subject: Re: Measurin the lag between a master and a replica