DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=XCpMy5JkLCywSAbBrdmC+B+8k0q8RQL9H+jQrZ9YRpt6sECWnG/FUZ2NBmPxC9pDKf
	IkHZ/w5FLa37taYtj1R8A1GZMKhW9AH1wa1U21TAJhDsipJ6I/nLoalxAgN4tu6q8B/l
	knp/F1yMgk1PcB7qKIw1QYPmrNq46wRvupSCI=
MIME-Version: 1.0
In-Reply-To: <3f0b79eb1001131413v4ccc8ac1jf25a1f75cf71d5ce@mail.gmail.com>
References: <4B4DB022.4070209@enterprisedb.com>
	<3f0b79eb1001130357n6abc8466q6556daf2ab3c3fe2@mail.gmail.com>
	<4B4DBDBD.10304@enterprisedb.com>
	<3f0b79eb1001131413v4ccc8ac1jf25a1f75cf71d5ce@mail.gmail.com>
Date: Thu, 4 Mar 2010 21:00:33 +0900
Message-ID: <3f0b79eb1003040400w41ced642ua37a0031850c3a5@mail.gmail.com>
Subject: Re: Incrementally Updated Backups and restartpoints
From: Fujii Masao <masao.fujii@gmail.com>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I thought of this issue again since the related question arrived.
http://archives.postgresql.org/pgsql-admin/2010-03/msg00036.php

On Thu, Jan 14, 2010 at 7:13 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Wed, Jan 13, 2010 at 9:34 PM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> 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.
>
> OK. That assumption should be documented?

This comment is meaningless. Sorry for noise.

> And, when we start an archive recovery from the backup from the standby,
> we seem to reach a safe starting point before database has actually become
> consistent. It's because backupStartLoc is zero. Isn't this an issue?

This issue seems to still happen. So should this be fixed for 9.0?
Or only writing a note in document is enough for 9.0? I'm leaning
towards the latter.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center