Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 7A9BA1337B98 for ; Wed, 2 Feb 2011 19:43:33 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 97454-08-2 for ; Wed, 2 Feb 2011 23:43:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id B3F851337BA5 for ; Wed, 2 Feb 2011 19:43:21 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id D8615118DD3; Wed, 2 Feb 2011 18:43:21 -0500 (EST) Date: Wed, 2 Feb 2011 18:43:21 -0500 From: Ray Stell To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: unexpected pageaddr Message-ID: <20110202234321.GA22981@cns.vt.edu> References: <20110202204651.GA10182@cns.vt.edu> <5031.1296689542@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5031.1296689542@sss.pgh.pa.us> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/5 X-Sequence-Number: 36644 On Wed, Feb 02, 2011 at 06:32:22PM -0500, Tom Lane wrote: > Ray Stell writes: > > Streaming replication standby moved from 9.0.2->9.0.3 logs this up > > startup: > > > database system was shut down in recovery at 2011-02-02 15:28:51 EST > > entering standby mode > > redo starts at 0/65000170 > > consistent recovery state reached at 0/66000000 > > unexpected pageaddr 0/62000000 in log file 0, segment 102, offset 0 > > database system is ready to accept read only connections > > streaming replication successfully connected to primary > > > Is the standby hurt? > > "unexpected pageaddr" is just one of the standard tests for detecting > end of WAL, so I don't think this is anything to be surprised about. > It looks to me like the standby applied all the WAL it had and then > connected to the master for more. > > regards, tom lane thanks, Tom. I suppose it's the order that trips me up: starts at 65... reached a 66... unexpected at 62... Maybe you could say a few words on the flow logic. I suppose it depends on what is meant by "start."