Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"

I have set  stats_temp_directory to postgresql/data/pg_stat_tmp, but still
this message is coming and also  created pgstat.tmp file in that location
manually, but this file is getting removed automatically in few minutes.

postgresql/data/pg_stat_tmp> touch pgstat.tmp
postgresql/data/pg_stat_tmp> ls -rtl
total 96
-rw-r--r-- 1 novell novell     0 2011-06-15 23:36 a
-rw------- 1 novell novell 92446 2011-06-16 21:23 pgstat.stat
-rw------- 1 novell novell     0 2011-06-16 21:23 pgstat.tmp

postgresql/data/pg_stat_tmp> ls -rtl
total 96
-rw-r--r-- 1 novell novell     0 2011-06-15 23:36 a
-rw------- 1 novell novell 92446 2011-06-16 21:23 pgstat.stat
-rw------- 1 novell novell     0 2011-06-16 21:23 pgstat.tmp

postgresql/data/pg_stat_tmp> ls -rtl
total 96
-rw-r--r-- 1 novell novell     0 2011-06-15 23:36 a
-rw------- 1 novell novell 92446 2011-06-16 21:23 pgstat.stat

Any idea?
Thanks.


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-tmp-tp4493683p4497611.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.