Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: bakkiya <bakkiya(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Date: 2011-06-16 06:59:15
Message-ID: 21195.1308207555@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> On Thu, Jun 16, 2011 at 7:44 AM, bakkiya <bakkiya(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bernhard Schrader 2011-06-16 12:21:44 Missing clogs and pg_upgrade. What to do without any clog backup?
Previous Message bakkiya 2011-06-16 06:56:12 Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"