autovacuum: found orphan temp table

From: Nicolau Roca <nicolau(dot)roca(at)uib(dot)cat>
To: pgsql-general(at)postgresql(dot)org
Subject: autovacuum: found orphan temp table
Date: 2013-06-25 13:13:01
Message-ID: 51C9975D.1040508@uib.cat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
after a server crash the following messages appear in the log file every
minute:

2013-06-25 15:02:15 CEST [::18264:1:] LOG: autovacuum: found orphan
temp table "pg_temp_47"."est_backup_ids_temp" in database "estudis1314"
2013-06-25 15:02:15 CEST [::18264:2:] LOG: autovacuum: found orphan
temp table "pg_temp_47"."est_backup_files_temp" in database "estudis1314"

I read a suggestion in the list pgsql-hackers (Message ID
48F4599D(dot)7010601(at)enterprisedb(dot)com
<http://www.postgresql.org/message-id/48F4599D.7010601@enterprisedb.com>) about
just dropping the pg_temp_x schema. However, no such schema exists:

[postgres(at)postgresql1 ~]$ psql
psql (9.2.4)
Type "help" for help.

(postgres(at)[local]:5432) [postgres] > \dnS
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
pg_catalog | postgres
pg_temp_1 | postgres
pg_toast | postgres
pg_toast_temp_1 | postgres
pgpool_catalog | postgres
public | postgres
(7 rows)

So what could be done in order to get rid of the message?

Regards,
Nicolau

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-06-25 13:37:54 Re: .pgpass being ignored
Previous Message dinesh kumar 2013-06-25 13:08:39 PostgreSQL 9.3 pg_dump issue