Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9DB2B632693 for ; Thu, 11 Feb 2010 09:56:13 -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 34697-06 for ; Thu, 11 Feb 2010 13:55:54 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og105.obsmtp.com (exprod7og105.obsmtp.com [64.18.2.163]) by mail.postgresql.org (Postfix) with SMTP id 4CAEC6339C9 for ; Thu, 11 Feb 2010 09:56:02 -0400 (AST) Received: from source ([209.85.219.219]) by exprod7ob105.postini.com ([64.18.6.12]) with SMTP ID DSNKS3QMcABjk7Vmu2r9XOf05ikIuLtP3B0L@postini.com; Thu, 11 Feb 2010 05:56:01 PST Received: by ewy19 with SMTP id 19so1359671ewy.21 for ; Thu, 11 Feb 2010 05:55:59 -0800 (PST) Received: by 10.213.52.205 with SMTP id j13mr582669ebg.75.1265896559623; Thu, 11 Feb 2010 05:55:59 -0800 (PST) Received: from ?192.168.1.117? ([88.195.103.165]) by mx.google.com with ESMTPS id 23sm5520651eya.43.2010.02.11.05.55.58 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 11 Feb 2010 05:55:58 -0800 (PST) Message-ID: <4B740C6C.3010607@enterprisedb.com> Date: Thu, 11 Feb 2010 15:55:56 +0200 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706) MIME-Version: 1.0 To: Simon Riggs CC: Dimitri Fontaine , Fujii Masao , PostgreSQL-development Subject: Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL References: <20100127152751.3B2047541B9@cvs.postgresql.org> <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> <877hqjc2kk.fsf@hi-media-techno.com> <1265896250.7341.1627.camel@ebony> In-Reply-To: <1265896250.7341.1627.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.396 tagged_above=-10 required=5 tests=AWL=0.203, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/857 X-Sequence-Number: 157200 Simon Riggs wrote: > One question then: how do we ensure that the archive does not grow too > big? pg_standby cleans down the archive using %R. That function appears > to not exist anymore. You can still use %R. Of course, plain 'cp' won't know what to do with it, so a script will then be required. We should probably provide a sample of that in the docs, or even a ready-made tool similar to pg_standby but without the waiting. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com