Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C290EB5D8BD for ; Thu, 16 Jun 2011 03:59:25 -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 67725-07 for ; Thu, 16 Jun 2011 06:59:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 659F9B5D803 for ; Thu, 16 Jun 2011 03:59:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p5G6xFcK021196; Thu, 16 Jun 2011 02:59:15 -0400 (EDT) To: Simon Riggs cc: bakkiya , pgsql-admin Subject: Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" In-reply-to: References: <1308202086880-4493683.post@n5.nabble.com> <1308206643749-4493814.post@n5.nabble.com> Comments: In-reply-to Simon Riggs message dated "Thu, 16 Jun 2011 07:50:45 +0100" Date: Thu, 16 Jun 2011 02:59:15 -0400 Message-ID: <21195.1308207555@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/94 X-Sequence-Number: 37720 Simon Riggs writes: > On Thu, Jun 16, 2011 at 7:44 AM, bakkiya wrote: >> Space,permission are not an issue. > Then presumably you have your stats_temp_directory parameter set to a > path where that is not true. But the error message is showing the specific file path that the stats collector tried to open. I'm wondering whether the OP is confused about which data directory is in use. It's pretty hard to explain "No such file or directory" by any theory other than that pg_stat_tmp isn't really there in the server's CWD. regards, tom lane