Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 505C0633A95 for ; Wed, 13 Jan 2010 08:34:23 -0400 (AST) 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 66670-08 for ; Wed, 13 Jan 2010 12:34:05 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og121.obsmtp.com (exprod7og121.obsmtp.com [64.18.2.20]) by mail.postgresql.org (Postfix) with SMTP id D405E63382C for ; Wed, 13 Jan 2010 08:34:11 -0400 (AST) Received: from source ([209.85.219.220]) by exprod7ob121.postini.com ([64.18.6.12]) with SMTP ID DSNKS029wY3S8SkLGVG1uZFd2duE9ushfKke@postini.com; Wed, 13 Jan 2010 04:34:11 PST Received: by ewy20 with SMTP id 20so4220814ewy.20 for ; Wed, 13 Jan 2010 04:34:09 -0800 (PST) Received: by 10.213.23.203 with SMTP id s11mr1032549ebb.60.1263386048874; Wed, 13 Jan 2010 04:34:08 -0800 (PST) Received: from ?192.168.1.117? ([88.195.103.165]) by mx.google.com with ESMTPS id 28sm9006974eye.9.2010.01.13.04.34.06 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 13 Jan 2010 04:34:07 -0800 (PST) Message-ID: <4B4DBDBD.10304@enterprisedb.com> Date: Wed, 13 Jan 2010 14:34:05 +0200 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706) MIME-Version: 1.0 To: Fujii Masao CC: PostgreSQL-development Subject: Re: Incrementally Updated Backups and restartpoints References: <4B4DB022.4070209@enterprisedb.com> <3f0b79eb1001130357n6abc8466q6556daf2ab3c3fe2@mail.gmail.com> In-Reply-To: <3f0b79eb1001130357n6abc8466q6556daf2ab3c3fe2@mail.gmail.com> 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.416 tagged_above=-10 required=5 tests=AWL=0.183, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201001/1346 X-Sequence-Number: 154567 Fujii Masao wrote: > On Wed, Jan 13, 2010 at 8:36 PM, Heikki Linnakangas > wrote: >> I wonder if it would be enough to document that pg_control must be >> backed up first? > > Probably No. The archive recovery from such base backup would always > fail at the end of recovery because there is no backup-end record, > i.e., pg_stop_backup() is not executed in that case. No, that's not an issue. We only wait for the backup-end record if we haven't seen yet since we started recovery from the base backup. Assuming the standby had reached that point already before the new backup from the standby started, backupStartLoc is zero in the control file. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com