Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id B42C17E4445 for ; Fri, 22 Jun 2012 15:46:51 -0300 (ADT) Received: from vexbert.mr-paradox.net ([2001:470:b:28:f::1]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Si8sY-0001zj-Ow for pgsql-performance@postgresql.org; Fri, 22 Jun 2012 18:46:50 +0000 Received: by vexbert.mr-paradox.net (Postfix, from userid 18391) id 7BB1C84640; Fri, 22 Jun 2012 14:46:32 -0400 (EDT) Date: Fri, 22 Jun 2012 11:46:32 -0700 From: David Kerr To: pgsql-performance@postgresql.org Subject: "global/pgstat.stat" corrupt Message-ID: <20120622184632.GE94572@mr-paradox.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.3i X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/121 X-Sequence-Number: 47147 Howdy, I just restored a DB from a cold backup (pg_ctl stop -m fast) When starting the DB I see: LOG: corrupted statistics file "global/pgstat.stat" When I look at the filesystem I don't see a global/pgstat.stat file but i do see a pg_stat_tmp/pgstat.stat is that PG rebuilding the corrupt file? Are those stats related to pg_stats style statistics? Any idea why that pgstats.stat file would be corrupt after a relativly clean backup like that?