X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 47AA39DC847 for ; Thu, 23 Feb 2006 10:26:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64201-01 for ; Thu, 23 Feb 2006 10:26:46 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 0CF2A9DC806 for ; Thu, 23 Feb 2006 10:26:40 -0400 (AST) Received: from [192.168.0.5] (unknown [84.12.26.47]) by smtp.nildram.co.uk (Postfix) with ESMTP id 54DEA266CF5; Thu, 23 Feb 2006 14:25:08 +0000 (GMT) Subject: Re: WAL recovery From: Simon Riggs To: andy.shellam@mailnetwork.co.uk Cc: pgsql-admin@postgresql.org In-Reply-To: <43FC90C9.3090204@mailnetwork.co.uk> References: <43FC90C9.3090204@mailnetwork.co.uk> Content-Type: text/plain Date: Thu, 23 Feb 2006 14:24:22 +0000 Message-Id: <1140704662.8759.121.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200602/273 X-Sequence-Number: 20694 On Wed, 2006-02-22 at 16:26 +0000, Andy Shellam wrote: > Is this scenario possible - that you can keep rolling forward over log > files as long as necessary, or do you always have to start from a base > backup? Nothing is changing on the spare, it's literally a sitting > duck. You'll need a restore_command that is a script that sits in a wait loop when the file it is asked for is not available yet, or other conditions have occurred such as notification of switchover (manually or otherwise). When those conditions occur the script should return a non-zero error condition. There should be no recovery_target* settings. Best Regards, Simon Riggs