Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E9C8663226F for ; Thu, 15 Jan 2009 13:34:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26884-01-9 for ; Thu, 15 Jan 2009 13:34:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137166.authsmtp.co.uk (outmail137166.authsmtp.co.uk [62.13.137.166]) by mail.postgresql.org (Postfix) with ESMTP id B78F562DBD9 for ; Thu, 15 Jan 2009 13:32:29 -0400 (AST) Received: from mail-c188.authsmtp.com (mail-c188.authsmtp.com [62.13.128.25]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n0FHWAQ5084492; Thu, 15 Jan 2009 17:32:10 GMT Received: from [192.168.0.3] (85-211-98-195.dyn.gotadsl.co.uk [85.211.98.195]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n0FHW9Tk055942; Thu, 15 Jan 2009 17:32:09 GMT Subject: Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION From: Simon Riggs To: Tom Lane Cc: Heikki Linnakangas , Fujii Masao , Bruce Momjian , Randy Isbell , pgsql-bugs@postgresql.org In-Reply-To: <6718.1232036141@sss.pgh.pa.us> References: <200901150150.n0F1oV113850@momjian.us> <496F2795.70105@enterprisedb.com> <3f0b79eb0901150615g133f845erc39faf19793d5977@mail.gmail.com> <496F5502.4020907@enterprisedb.com> <6718.1232036141@sss.pgh.pa.us> Content-Type: text/plain Date: Thu, 15 Jan 2009 17:33:44 +0000 Message-Id: <1232040824.31921.76.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 6fe6c4a1-e32a-11dd-aecc-001871e930f4 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacBtFaQBbZ1hf HGQLW11EUVp7WmF/ awMfZQBDYEtPQQxi TklAR01QEQdtHhxP WB5oKn57E15GfXt5 YUQsX3hTVAp8IxN7 EUoFFHBTZmUxdWEe BBRFJlYHIx5Kfh5N bVEqXXANN2FJBC9q VzwZAh8KCH11FQsd CV1QcwxACV4EKSUg QAg1FzwkHlAdB2R7 NRE+LUQABw4QNE41 K0EsUk5QCCM1MkVh NmUvYQt+DHA9Zg0N ZXZl X-Authentic-SMTP: 61633235383639.cat.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/99 X-Sequence-Number: 22081 On Thu, 2009-01-15 at 11:15 -0500, Tom Lane wrote: > Heikki Linnakangas writes: > > Fujii Masao wrote: > >> Only a part of backup > >> history file (the file name including stop wal location) is changed. > >> Currently, the file name is wrong if stop wal location indicates a boundary > >> byte. This would confuse the user, I think. > > > Should we change it in HEAD? I'm leaning towards no, on the grounds that > > tools/people would then have to know the version it's dealing with to > > interpret the value correctly, and because pg_stop_backup() now waits > > for the last xlog file to be archived before returning, there's little > > need to look at that file. > > I agree. It might have been better to define it the other way > originally, but the risks of changing it now outweigh any likely > benefit. Agreed. It's too confusing the other way. The manual entry wasn't changed from my original submission unfortunately. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support