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.