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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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