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 <bakk...@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 >