Re: corrupted statistics file "pg_stat_tmp/pgstat.stat"

Hi,

I've made the backups with pg_dump, compressed, and there wasn't any kind of error messages. I've made the restoration with pgAdmin (but it also uses pg_dump for restore).

How can I check if the statistics are corrupt?

regards,
Csaba

-----Original Message-----
From: Alban Hertroys [mailto:haramrae(at)gmail(dot)com]
Sent: Wednesday, August 15, 2012 3:33 PM
To: Carl von Clausewitz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] corrupted statistics file "pg_stat_tmp/pgstat.stat"

On 15 August 2012 09:57, Carl von Clausewitz <clausewitz45(at)gmail(dot)com> wrote:
> I’ve restored from TAR backup our databases, and everything looked fine.

What exactly is in that TAR backup? Is that a tar/gzipped PG dump or a file-system snapshot?
If the latter:
- did you halt the database while creating the snapshot or at least force a checkpoint?
- is the version of PG that you're restoring to exactly the same (same CPU type, same major/minor version of PG) as the one that the backup is from?

I suspect that you restored a database with corrupt statistics and that those only get found out once the corrupted statistics are needed.

--
If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.