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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
