Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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.

In response to

pgsql-admin by date

Next:From: Martin M√ľnstermannDate: 2011-06-17 08:40:57
Subject: archive_command vs. cp -i
Previous:From: Alban HertroysDate: 2011-06-16 18:30:07
Subject: Re: [GENERAL] Postgres 8.3.10 Alter Table Waiting issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group