X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 10E3DD1B7F0 for ; Wed, 21 Apr 2004 00:07:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43853-09 for ; Wed, 21 Apr 2004 00:07:57 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 553FFD1B4BE for ; Wed, 21 Apr 2004 00:07:57 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3L37tkS025208; Tue, 20 Apr 2004 23:07:55 -0400 (EDT) To: "Arthur Ward" Cc: pgsql-admin@postgresql.org Subject: Re: Unfamiliar recovery message afer server crash In-reply-to: <33720.68.62.129.152.1082478893.squirrel@award.gotdns.org> References: <33720.68.62.129.152.1082478893.squirrel@award.gotdns.org> Comments: In-reply-to "Arthur Ward" message dated "Tue, 20 Apr 2004 11:34:53 -0500" Date: Tue, 20 Apr 2004 23:07:55 -0400 Message-ID: <25207.1082516875@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/271 X-Sequence-Number: 13244 "Arthur Ward" writes: > Apr 20 11:28:14 postgres: [6203] LOG: database system was not properly > shut down; automatic recovery in progress > Apr 20 11:28:14 postgres: [6203] LOG: redo starts at 7C/CF55FBAC > Apr 20 11:28:17 postgres: [6203] LOG: unexpected pageaddr 7C/C7A0A000 in > log file 124, segment 207, offset 10526720 > Apr 20 11:28:17 postgres: [6203] LOG: redo done at 7C/CFA09F7C > Apr 20 11:28:20 postgres: [6203] LOG: database system is ready > What's the significance of the "unexpected pageaddr" item? Just that the first indication of end-of-XLOG was finding a stale page header in a recycled XLOG file. The above looks fine to me. (The XLOG recovery code tends to err on the side of verboseness... there are a lot of messages it can print that might boggle a novice but are not really indicative of problems.) regards, tom lane