Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 6BA262E0031 for ; Mon, 12 May 2008 22:16:04 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73810-02 for ; Mon, 12 May 2008 22:15:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from alexis.jtlnet.com (alexis.jtlnet.com [69.36.9.81]) by developer.postgresql.org (Postfix) with ESMTP id 4AAAF2E0039 for ; Mon, 12 May 2008 22:15:59 -0300 (ADT) Received: from [192.168.10.103] (cpe-075-177-177-228.nc.res.rr.com [::ffff:75.177.177.228]) (TLS: TLSv1/SSLv3,256bits,AES256-SHA) by alexis.jtlnet.com with esmtp; Mon, 12 May 2008 21:14:06 -0400 id 0008BBB9.4828EB5E.00006235 Message-ID: <4828EBCB.6010004@dunslane.net> Date: Mon, 12 May 2008 21:15:55 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20071019 Fedora/1.0.9-3.fc6 pango-text SeaMonkey/1.0.9 MIME-Version: 1.0 To: Simon Riggs CC: PostgreSQL-development Subject: Re: odd output in restore mode References: <4828AF1D.7060405@dunslane.net> <1210630440.29684.249.camel@ebony.site> <4828CB9D.7070102@dunslane.net> <1210635473.29684.268.camel@ebony.site> In-Reply-To: <1210635473.29684.268.camel@ebony.site> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/391 X-Sequence-Number: 118390 Simon Riggs wrote: > On Mon, 2008-05-12 at 18:58 -0400, Andrew Dunstan wrote: > > >> No, it had to do with pg_standby waiting for a WAL file that had already >> gone, somehow. I will try to reproduce it when I get a spare moment. >> > > Sounds like the bug I just fixed. > Yes, so I see. I didn't have that fix, so I'll test again with the patch. > > >>> There is an outstanding Windows issue with pg_standby that your help >>> would be appreciated with, shown on latest commitfest page. It's a >>> Windows issue and I don't maintain a Windows dev environment. >>> > > >> The patch has been rejected for now, according to the Commitfest page. >> Not sure what you want my help on. >> > > Well, the patch was rejected long ago, not sure why its in this > commitfest. But its an open issue on the Windows port. > > Surely the right fix is to use the recently implemented pgwin32_safestat() (if we aren't already - I suspect we probably are) and remove the kluge in pg_standby.c. cheers andrew