| From: | bakkiya <bakkiya(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" |
| Date: | 2011-06-17 04:29:26 |
| Message-ID: | 1308284966645-4497611.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Münstermann | 2011-06-17 08:40:57 | archive_command vs. cp -i |
| Previous Message | Alban Hertroys | 2011-06-16 18:30:07 | Re: [GENERAL] Postgres 8.3.10 Alter Table Waiting issue |