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