From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: bakkiya <bakkiya@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Date: Thu, 16 Jun 2011 02:59:15 -0400
Message-ID: <21195.1308207555@sss.pgh.pa.us> (raw)
In-Reply-To: <BANLkTi=nZ2Wdx7s5r74cy84t2sCQj0_DUA@mail.gmail.com>
References: <1308202086880-4493683.post@n5.nabble.com>
<BANLkTi=nKMkQzOD9ZZi3ZNEGyMxwAeJXow@mail.gmail.com>
<1308206643749-4493814.post@n5.nabble.com>
<BANLkTi=nZ2Wdx7s5r74cy84t2sCQj0_DUA@mail.gmail.com>
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Thu, Jun 16, 2011 at 7:44 AM, bakkiya <bakkiya@gmail.com> 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
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: tgl@sss.pgh.pa.us, simon@2ndQuadrant.com, bakkiya@gmail.com
Subject: Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
In-Reply-To: <21195.1308207555@sss.pgh.pa.us>
* 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