Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 201B063241F for ; Fri, 12 Feb 2010 03:37:57 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 53489-01 for ; Fri, 12 Feb 2010 07:37:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og102.obsmtp.com (exprod7og102.obsmtp.com [64.18.2.157]) by mail.postgresql.org (Postfix) with SMTP id CAE86632230 for ; Fri, 12 Feb 2010 03:37:45 -0400 (AST) Received: from source ([209.85.219.217]) by exprod7ob102.postini.com ([64.18.6.12]) with SMTP ID DSNKS3UFSEVbL6dXFpoQ9Q7i3w83YbJn+XFt@postini.com; Thu, 11 Feb 2010 23:37:45 PST Received: by ewy9 with SMTP id 9so2474991ewy.15 for ; Thu, 11 Feb 2010 23:37:43 -0800 (PST) Received: by 10.216.88.2 with SMTP id z2mr612496wee.89.1265960263377; Thu, 11 Feb 2010 23:37:43 -0800 (PST) Received: from ?192.168.1.117? ([88.195.103.165]) by mx.google.com with ESMTPS id 5sm704752eyf.4.2010.02.11.23.37.40 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 11 Feb 2010 23:37:41 -0800 (PST) Message-ID: <4B750544.40104@enterprisedb.com> Date: Fri, 12 Feb 2010 09:37:40 +0200 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706) MIME-Version: 1.0 To: Simon Riggs CC: Tom Lane , Aidan Van Dyk , Fujii Masao , PostgreSQL-development Subject: Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL References: <3f0b79eb1002092105r21e009d3v468496058ba04392@mail.gmail.com> <4B726120.80007@enterprisedb.com> <1265884657.7341.1192.camel@ebony> <4B73F678.8070109@enterprisedb.com> <1265891248.7341.1346.camel@ebony> <4B73FB99.4080403@enterprisedb.com> <1265893599.7341.1454.camel@ebony> <4B740613.5090004@enterprisedb.com> <20100211140118.GB14128@oak.highrise.ca> <4B74118C.30704@enterprisedb.com> <20100211144204.GC14128@oak.highrise.ca> <4B7438A9.8090902@enterprisedb.com> <11741.1265911704@sss.pgh.pa.us> <1265912052.7341.2276.camel@ebony> In-Reply-To: <1265912052.7341.2276.camel@ebony> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.401 tagged_above=-10 required=5 tests=AWL=0.198, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/984 X-Sequence-Number: 157327 Simon Riggs wrote: > On Thu, 2010-02-11 at 13:08 -0500, Tom Lane wrote: >> Heikki Linnakangas writes: >>> -1. it isn't necessary for PITR. It's a new requirement for >>> standby_mode='on', unless we add the file size check into the backend. I >>> think we should add the file size check to the backend instead and save >>> admins the headache. >> I think the file size check needs to be in the backend purely on safety >> grounds. Whether we make pg_standby useful for this context is a >> different discussion. > > Happy with that. Committed such a check now. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com