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
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 |