Skip site navigation (1) Skip section navigation (2)

Re: Incrementally Updated Backups and restartpoints

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Incrementally Updated Backups and restartpoints
Date: 2010-03-04 12:00:33
Message-ID: 3f0b79eb1003040400w41ced642ua37a0031850c3a5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
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(dot)fujii(at)gmail(dot)com> wrote:
> On Wed, Jan 13, 2010 at 9:34 PM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)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

In response to

Responses

pgsql-docs by date

Next:From: Magnus HaganderDate: 2010-03-05 17:32:01
Subject: startup or start-up
Previous:From: Bruce MomjianDate: 2010-03-03 03:14:18
Subject: Re: CREATE FUNCTION reference page's Notes section is getting out of hand

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-03-04 12:11:36
Subject: Re: HS/SR and smart shutdown
Previous:From: Andrew DunstanDate: 2010-03-04 11:53:04
Subject: Re: USE_LIBXSLT in MSVC builds

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group