Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7E9DEB5DBC0 for ; Fri, 17 Jun 2011 01:29:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 02921-10 for ; Fri, 17 Jun 2011 04:29:28 +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 03767B5D944 for ; Fri, 17 Jun 2011 01:29:27 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QXQgQ-0006t9-L2 for pgsql-admin@postgresql.org; Thu, 16 Jun 2011 21:29:26 -0700 Date: Thu, 16 Jun 2011 21:29:26 -0700 (PDT) From: bakkiya To: pgsql-admin@postgresql.org Message-ID: <1308284966645-4497611.post@n5.nabble.com> In-Reply-To: <21195.1308207555@sss.pgh.pa.us> References: <1308202086880-4493683.post@n5.nabble.com> <1308206643749-4493814.post@n5.nabble.com> <21195.1308207555@sss.pgh.pa.us> 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/101 X-Sequence-Number: 37727 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.