Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2F7189FA5CF for ; Wed, 29 Aug 2007 13:02:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33124-01-7 for ; Wed, 29 Aug 2007 13:02:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 77D6E9FA5FD for ; Wed, 29 Aug 2007 13:01:49 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Wed, 29 Aug 2007 11:01:48 -0500 Message-Id: <46D55209.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Wed, 29 Aug 2007 11:01:29 -0500 From: "Kevin Grittner" To: "Simon Riggs" , "Robert Treat" Cc: ,"Tom Lane" Subject: Re: how is pitr replay interruption time determined? References: <200708271742.57392.xzilla@users.sourceforge.net> <4555.1188338360@sss.pgh.pa.us> <1188341069.4218.93.camel@ebony.site> <200708291048.54662.xzilla@users.sourceforge.net> In-Reply-To: <200708291048.54662.xzilla@users.sourceforge.net> 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: 200708/396 X-Sequence-Number: 26727 >>> On Wed, Aug 29, 2007 at 9:48 AM, in message <200708291048.54662.xzilla@users.sourceforge.net>, Robert Treat wrote:=20 > Looking at last checkpoint location in pg_control, I see: > Latest checkpoint location: 1C/8001E848 >=20 > How does one translate that into an xlog file name?=20 Unless you've gotten fancy in a PITR recovery, it should be: =20 000000010000001C00000080 =20 01E848 is the offset into the file. =20 -Kevin =20