autovacuum: found orphan temp table

Поиск
Список
Период
Сортировка
От Nicolau Roca
Тема autovacuum: found orphan temp table
Дата
Msg-id 51C9975D.1040508@uib.cat
обсуждение исходный текст
Ответы Re: autovacuum: found orphan temp table  (Bosco Rama <postgres@boscorama.com>)
Re: autovacuum: found orphan temp table  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Список 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.7010601@enterprisedb.com) about just dropping the pg_temp_x schema. However, no such schema exists:

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

(postgres@[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

В списке pgsql-general по дате отправления:

Предыдущее
От: kathyn
Дата:
Сообщение: Data Minning and analisys tool for Postgres?
Следующее
От: Atri Sharma
Дата:
Сообщение: Re: Data Minning and analisys tool for Postgres?