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
