Postgres Pro
Downloads
Home   >   mailing lists

Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" - Mailing list pgsql-admin

From Tim
Subject Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Date
Msg-id BANLkTi=nKMkQzOD9ZZi3ZNEGyMxwAeJXow@mail.gmail.com
Whole thread Raw
In response to could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"  (bakkiya <bakkiya@gmail.com>)
Responses Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"  (bakkiya <bakkiya@gmail.com>)
List pgsql-admin
Tree view

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@gmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: bakkiya
Date:
Subject: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Next
From: Simon Riggs
Date:
Subject: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"