Skip site navigation (1) Skip section navigation (2)

Re: BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"

From: Euler Taveira <euler(at)timbira(dot)com>
To: shenqw(at)163(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"
Date: 2012-08-24 14:22:33
Message-ID: 50378E29.2000704@timbira.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 24-08-2012 00:16, shenqw(at)163(dot)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


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-08-24 14:38:27
Subject: Re: Minor inheritance/check bug: Inconsistent behavior
Previous:From: Chris TraversDate: 2012-08-24 14:18:15
Subject: Re: Minor inheritance/check bug: Inconsistent behavior

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group