X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 2352D11F60E9 for ; Tue, 18 Apr 2006 16:58:16 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.297 X-Spam-Level: X-Spam-Status: No, score=-2.297 required=5 tests=[AWL=0.304, BAYES_00=-2.599, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id mq7yq6M7y92i for ; Tue, 18 Apr 2006 16:57:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F008311F61ED for ; Tue, 18 Apr 2006 16:57:57 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3IJvthH018516; Tue, 18 Apr 2006 15:57:55 -0400 (EDT) To: "Thomas F. O'Connell" cc: pgsql-admin@postgresql.org Subject: Re: Invalid Page Headers In-reply-to: References: <17920.1145387726@sss.pgh.pa.us> Comments: In-reply-to "Thomas F. O'Connell" message dated "Tue, 18 Apr 2006 14:45:33 -0500" Date: Tue, 18 Apr 2006 15:57:55 -0400 Message-ID: <18515.1145390275@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/171 X-Sequence-Number: 21340 "Thomas F. O'Connell" writes: > In the meantime, should I leave the database online while I attempt > to recover? It's still unclear to me whether postgres will restart > with invalid page headers. I certainly can't run pg_dumpall, for > instance. Has the database successfully checkpointed since the last error occurrence? If so, I wouldn't foresee any problem with a shutdown. If checkpoints are failing then you probably won't be able to shut down without getting the same error. (Use pg_controldata if you're not sure about when the last checkpoint happened.) > I'm glad that there have so far been only 3 relations affected... :( You mean, three that you know about :-( regards, tom lane