Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1B6789FC1D3 for ; Fri, 29 Jun 2007 14:12:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 77631-03 for ; Fri, 29 Jun 2007 14:12:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 544359FB4C9 for ; Fri, 29 Jun 2007 14:12:21 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 29 Jun 2007 12:12:20 -0500 Message-Id: <4684F718.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Fri, 29 Jun 2007 12:12:08 -0500 From: "Kevin Grittner" To: "George Wilk" ,"Tom Lane" Cc: Subject: Re: missing history file References: <00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com><00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com> <5332.1183135679@sss.pgh.pa.us> In-Reply-To: <5332.1183135679@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/306 X-Sequence-Number: 25974 >>> On Fri, Jun 29, 2007 at 11:47 AM, in message <5332.1183135679@sss.pgh.p= a.us>, Tom Lane wrote:=20 >=20 > History files are only created when you do a PITR recovery that stops > short of the end of WAL (ie, you gave it an explicit stopping point > criterion). So basically they never appear except by manual > intervention on the primary server. A standby script should probably > handle requests for them by looking to see if they're available, and > returning 'em if so, but not waiting if they are not. >=20 > Offhand I would recommend the same strategy for any requested filename > that's not a plain WAL segment file (ie, all hex digits). =20 I suspect that it's worth waiting for something like this, too?: =20 000000010000000A000000CF.0000E744.backup =20