Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DB7336339A6 for ; Tue, 12 May 2009 08:38:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54760-10 for ; Tue, 12 May 2009 08:38:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og124.obsmtp.com (exprod7og124.obsmtp.com [64.18.2.26]) by mail.postgresql.org (Postfix) with SMTP id 1E3E0633957 for ; Tue, 12 May 2009 08:38:15 -0300 (ADT) Received: from source ([209.85.219.175]) by exprod7ob124.postini.com ([64.18.6.12]) with SMTP ID DSNKSglfppE83YM4aUFRgbsYHE8ZNPfC8Dz/@postini.com; Tue, 12 May 2009 04:38:15 PDT Received: by ewy23 with SMTP id 23so4232113ewy.39 for ; Tue, 12 May 2009 04:38:13 -0700 (PDT) Received: by 10.216.36.84 with SMTP id v62mr3931724wea.128.1242128293713; Tue, 12 May 2009 04:38:13 -0700 (PDT) Received: from ?80.223.212.7? (dsl-hkibrasgw2-fed4df00-7.dhcp.inet.fi [80.223.212.7]) by mx.google.com with ESMTPS id 10sm1273364eyd.32.2009.05.12.04.38.12 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 12 May 2009 04:38:13 -0700 (PDT) Message-ID: <4A095FA3.7060304@enterprisedb.com> Date: Tue, 12 May 2009 14:38:11 +0300 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103) MIME-Version: 1.0 To: Simon Riggs CC: Fujii Masao , Guillaume Smet , Tom Lane , Peter Eisentraut , Kevin Grittner , pgsql-hackers Subject: Re: New trigger option of pg_standby 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> In-Reply-To: <1242127623.3843.237.camel@ebony.2ndQuadrant> 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: 200905/539 X-Sequence-Number: 138081 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. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com