Re: BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat" - Mailing list pgsql-bugs

From Euler Taveira
Subject Re: BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"
Date
Msg-id 50378E29.2000704@timbira.com
Whole thread Raw
In response to BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"  (shenqw@163.net)
Responses Re: BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"  (沈前卫 <shenqw@163.net>)
List pgsql-bugs
On 24-08-2012 00:16, shenqw@163.net wrote:
> Maybe this is a bug.
> if stats collector process don't product pg_stat_tmp/pgstat.stat file, the
> autovacuum launcher process will output those WARNING message?
>
It is possible but... Did you see any ERROR message(s) related to statistics
collector before those ones? To solver your problem, you can remove the
pgstat.stat file that it will be created again next time server starts. Of
course, you will loose the statistics, hence remember to VACUUM ANALYZE your
cluster.


--
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-bugs by date:

Previous
From: Chris Travers
Date:
Subject: Re: Minor inheritance/check bug: Inconsistent behavior
Next
From: Tom Lane
Date:
Subject: Re: Minor inheritance/check bug: Inconsistent behavior