Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 5EBD27E4447 for ; Fri, 22 Jun 2012 16:49:19 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Si9r0-0003CU-JR for pgsql-performance@postgresql.org; Fri, 22 Jun 2012 19:49:18 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q5MJn0fB017701; Fri, 22 Jun 2012 15:49:01 -0400 (EDT) From: Tom Lane To: David Kerr cc: pgsql-performance@postgresql.org Subject: Re: "global/pgstat.stat" corrupt In-reply-to: <20120622184632.GE94572@mr-paradox.net> References: <20120622184632.GE94572@mr-paradox.net> Comments: In-reply-to David Kerr message dated "Fri, 22 Jun 2012 11:46:32 -0700" Date: Fri, 22 Jun 2012 15:49:00 -0400 Message-ID: <17700.1340394540@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/122 X-Sequence-Number: 47148 David Kerr writes: > 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" Is that repeatable? It wouldn't be too surprising to see this once when starting from a filesystem backup, if you'd managed to capture a partially written stats file in the backup. > 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 This is normal --- global/pgstat.stat is only supposed to exist when the system is shut down. Transient updates are written into pg_stat_tmp/ > Are those stats related to pg_stats style statistics? No, this file is for the stats collection subsystem, http://www.postgresql.org/docs/9.1/static/monitoring-stats.html regards, tom lane