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.7010...@enterprisedb.com <http://www.postgresql.org/message-id/48f4599d.7010...@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

Reply via email to