Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 6F8A1635206 for ; Tue, 12 May 2009 11:32:06 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 57723-01 for ; Tue, 12 May 2009 11:31:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137063.authsmtp.net (outmail137063.authsmtp.net [62.13.137.63]) by mail.postgresql.org (Postfix) with ESMTP id 9097F6352F1 for ; Tue, 12 May 2009 11:31:55 -0300 (ADT) Received: from mail-c188.authsmtp.com (mail-c188.authsmtp.com [62.13.128.25]) by punt4.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n4CEVf7b027979; Tue, 12 May 2009 15:31:41 +0100 (BST) Received: from [192.168.0.2] (85-211-96-202.dyn.gotadsl.co.uk [85.211.96.202]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n4CEVdTP003614; Tue, 12 May 2009 15:31:39 +0100 (BST) Subject: Re: New trigger option of pg_standby From: Simon Riggs To: Heikki Linnakangas Cc: Fujii Masao , Guillaume Smet , Tom Lane , Peter Eisentraut , Kevin Grittner , pgsql-hackers In-Reply-To: <4A095FA3.7060304@enterprisedb.com> References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> <49DDEE72.6030803@enterprisedb.com> <3f0b79eb0904092047w355e0b3ar527a9285b161ef91@mail.gmail.com> <1239381103.16396.30.camel@ebony.2ndQuadrant> <3f0b79eb0904122252t1f4c5860v919d199f399ccf72@mail.gmail.com> <3f0b79eb0904132241p18084914g792cb8e5ab3eebb3@mail.gmail.com> <3f0b79eb0904150101pb1c59a3ubb422867e8e6a944@mail.gmail.com> <49EE1E3F.9050307@enterprisedb.com> <3f0b79eb0904212209i7fbd8b68k71db1fef09c62751@mail.gmail.com> <49F01D79.8020805@enterprisedb.com> <3f0b79eb0904230515p751b5248n6ef96880617db055@mail.gmail.com> <4A095A39.3030100@enterprisedb.com> <1242127623.3843.237.camel@ebony.2ndQuadrant> <4A095FA3.7060304@enterprisedb.com> Content-Type: text/plain Date: Tue, 12 May 2009 15:34:10 +0100 Message-Id: <1242138850.3843.259.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 9b64d910-3f01-11de-aecc-001871e930f4 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacRtFaQdbYFhI HGQLW11EUVh7WmJ/ bwofZQBDYEtPQQxs TkpJQE1QEQdtHhxP WBptJ38mE2VGeH12 ZEIsXHFfXQpzJ0B5 FkdVFXAFM2dhdWEe BBVFJlYHIx5Kfh5N bVEqXXANN2FJBC9q VzwTFhsSEA9kHWxz Tx5FMUgTTkkGBHY7 XwwDGjNnGkNNXyoE NAAvLFIWDS41 X-Authentic-SMTP: 61633235383639.cat.dmpriest.net.uk:1562/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.052 tagged_above=0 required=5 tests=AWL=0.052 X-Spam-Level: X-Archive-Number: 200905/542 X-Sequence-Number: 138084 On Tue, 2009-05-12 at 14:38 +0300, Heikki Linnakangas wrote: > Simon Riggs wrote: > > On Tue, 2009-05-12 at 14:15 +0300, Heikki Linnakangas wrote: > > > >> Here's another idea: Let's modify xlog.c so that when the server asks > >> for WAL file X, and restore_command returns "not found", the server > >> will not ask for any WAL files >= X again (in that recovery session). > >> Presumably if X doesn't exist, no later files will exist either. > > > > That was proposed and rejected earlier, though not in this context. > > Got a link? I'd like to check the past discussion. I'm sorry, I don't. One of the recovery related discussions started by me. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support