| 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: | Whole Thread | Raw Message | 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
>
| 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" |