Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5F49F632347 for ; Thu, 15 Jan 2009 13:44:28 -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 37282-05-6 for ; Thu, 15 Jan 2009 13:44:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 93E566323A2 for ; Thu, 15 Jan 2009 13:43:25 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id n0FHh6f16596; Thu, 15 Jan 2009 12:43:06 -0500 (EST) From: Bruce Momjian Message-Id: <200901151743.n0FHh6f16596@momjian.us> Subject: Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION In-Reply-To: <1232040824.31921.76.camel@ebony.2ndQuadrant> To: Simon Riggs Date: Thu, 15 Jan 2009 12:43:06 -0500 (EST) CC: Tom Lane , Heikki Linnakangas , Fujii Masao , Randy Isbell , pgsql-bugs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" 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/100 X-Sequence-Number: 22082 Simon Riggs wrote: > > 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. OK, do you have updated wording? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +