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@xxxxxxxxx] Sent: Wednesday, August 15, 2012 3:33 PM To: Carl von Clausewitz Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: corrupted statistics file "pg_stat_tmp/pgstat.stat" On 15 August 2012 09:57, Carl von Clausewitz <clausewitz45@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
