Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DC1969FA6B3; Fri, 5 Jan 2007 18:20:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 34131-02; Fri, 5 Jan 2007 18:19:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 744E39FA6BB; Fri, 5 Jan 2007 18:19:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from www.3times25.net (66-23-211-34.clients.speedfactory.net [66.23.211.34]) by svr4.postgresql.org (Postfix) with ESMTP id 9CEF15AF8A6; Fri, 5 Jan 2007 22:19:23 +0000 (GMT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by www.3times25.net (Postfix) with ESMTP id 597735401E; Fri, 5 Jan 2007 17:19:21 -0500 (EST) Message-ID: <459ECEE8.5030806@3times25.net> Date: Fri, 05 Jan 2007 17:19:20 -0500 From: Geoffrey User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: vacuum fails with 'invalid page header' message References: <459EC34E.3070304@3times25.net> In-Reply-To: <459EC34E.3070304@3times25.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/48 X-Sequence-Number: 24204 Geoffrey wrote: > We had a vacuum fail recently with the following error: > > invalid page header in block 846 of relation "move_pkey" > > Anyone have an idea what could cause this problem and what we need to do > to resolve it? > > Running on Red Hat Enterprise 3, postgres 7.4.13 Regarding the issue above, is it possible that re-indexing the database could resolve the problem, since the error is related to an index. move_pkey is an index on field recid. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin