Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 5F56AB5D8BD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 16 Jun 2011 03:44:11 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 58394-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 16 Jun 2011 06:44:04 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from sam.nabble.com (sam.nabble.com [216.139.236.26])
	by mail.postgresql.org (Postfix) with ESMTP id 96857B5D803
	for <pgsql-admin@postgresql.org>; Thu, 16 Jun 2011 03:44:04 -0300 (ADT)
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <bakkiya@gmail.com>) id 1QX6J9-0000aU-OP
	for pgsql-admin@postgresql.org; Wed, 15 Jun 2011 23:44:03 -0700
Date: Wed, 15 Jun 2011 23:44:03 -0700 (PDT)
From: bakkiya <bakkiya@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1308206643749-4493814.post@n5.nabble.com>
In-Reply-To: <BANLkTi=nKMkQzOD9ZZi3ZNEGyMxwAeJXow@mail.gmail.com>
References: <1308202086880-4493683.post@n5.nabble.com>
	<BANLkTi=nKMkQzOD9ZZi3ZNEGyMxwAeJXow@mail.gmail.com>
Subject: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.766 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001,
	T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122
X-Spam-Level: 
X-Archive-Number: 201106/90
X-Sequence-Number: 37716

postgresql/data/pg_stat_tmp> df -h .
Filesystem            Size  Used Avail Use% Mounted on
/dev/xvdb1            197G   16G  171G   9% /pub

postgresql/data/pg_stat_tmp> touch a
novell@s210:/pub/var/opt/novell/sentinel/3rdparty/postgresql/data/pg_stat_tmp>
ls -rtl
total 96
-rw------- 1 novell novell 91898 2011-06-15 23:36 pgstat.stat
-rw-r--r-- 1 novell novell     0 2011-06-15 23:36 a

/postgresql/data/pg_stat_tmp> uname -a
Linux s210 2.6.32.12-0.7-xen #1 SMP 2010-05-20 11:14:20 +0200 x86_64 x86_64
x86_64 GNU/Linux

Space,permission are not an issue.

Thanks.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-tmp-tp4493683p4493814.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.