Re: Problem with streaming replication, backups, and recovery (9.0.x)

Fujii Masao <masao.fujii@gmail.com>

View thread

From: Fujii Masao <masao.fujii@gmail.com>

To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

Cc: depesz@depesz.com, pgsql-hackers@postgresql.org

Date: 2011-03-30T06:25:30Z

Lists: pgsql-hackers

Attachments

backup_stop_location_v1.patch (application/octet-stream) patch v1

On Wed, Mar 30, 2011 at 11:39 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Wed, Mar 30, 2011 at 12:54 AM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> Hmm, why did we change that?
>
> I'm not sure, but I guess that's because I missed the case where crash
> recovery starts from the backup :(
>
>> It seems like a mistake, the database is not
>> consistent until you reach the backup stop location, whether or not you're
>> doing archive recovery. +1 for reverting that, and backpatching it as well.
>
> Agreed.

Attached patch reverts that. Comments?

Regards,

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