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
