From: bakkiya <bakkiya@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Date: Thu, 16 Jun 2011 21:29:26 -0700 (PDT)
Message-ID: <1308284966645-4497611.post@n5.nabble.com> (raw)
In-Reply-To: <21195.1308207555@sss.pgh.pa.us>
References: <1308202086880-4493683.post@n5.nabble.com>
<BANLkTi=nKMkQzOD9ZZi3ZNEGyMxwAeJXow@mail.gmail.com>
<1308206643749-4493814.post@n5.nabble.com>
<BANLkTi=nZ2Wdx7s5r74cy84t2sCQj0_DUA@mail.gmail.com>
<21195.1308207555@sss.pgh.pa.us>
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-...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bakkiya@gmail.com
Subject: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
In-Reply-To: <1308284966645-4497611.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox