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
chmod 0777 pg_stat_tmp/pgstat.tmp
ls -halZ pg_stat_tmp
On Thu, Jun 16, 2011 at 1:28 AM, bakkiya <bakkiya@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
