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

From: Tim <elatllat(at)gmail(dot)com>
To: bakkiya <bakkiya(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Date: 2011-06-16 06:23:26
Message-ID: BANLkTi=nKMkQzOD9ZZi3ZNEGyMxwAeJXow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I don't know but I would try this first:
touch pg_stat_tmp/pgstat.tmp
chmod 0777 pg_stat_tmp/pgstat.tmp
ls -halZ pg_stat_tmp

On Thu, Jun 16, 2011 at 1:28 AM, bakkiya <bakkiya(at)gmail(dot)com> wrote:

> Hi,
> We have postgresql9.0 in our Linux server. We are continously getting
> "could
> not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No such file
> or
> directory" message in the db log file.We have data/pg_stat_tmp directory
> in,
> but pgstat.tmp file is not ppresent in this directory.Can someone tell us
> why this error messgae is logged?
>
> Thanks.
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-tmp-tp4493683p4493683.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2011-06-16 06:34:23 Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Previous Message bakkiya 2011-06-16 05:28:06 could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"