Re: Backup history file should be replicated in Streaming Replication? - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Backup history file should be replicated in Streaming Replication?
Date
Msg-id 3f0b79eb0912040506x6ed25ae1t1c44211fe28c44b5@mail.gmail.com
Whole thread Raw
In response to Re: Backup history file should be replicated in Streaming Replication?  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Backup history file should be replicated in Streaming Replication?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Hi,

On Thu, Nov 26, 2009 at 5:20 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Thu, Nov 26, 2009 at 5:17 PM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> Yeah, that needs to be addressed regardless of HS, because you can
>> otherwise start up (= fail over to) the standby too early, before the
>> minimum recovery point has been reached.
>
> Okey, I address that ASAP.

pg_stop_backup deletes the previous backup history file from pg_xlog.
So replication of a backup history file would fail if just one new
online-backup is caused after the base-backup for the standby is taken.
This is too aggressive deletion policy for Streaming Replication, I think.

So I'd like to change pg_stop_backup so as to delete only backup
history files of four or more generations ago (four is enough?).

Thought?

Regards,

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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Block-level CRC checks
Next
From: Heikki Linnakangas
Date:
Subject: Re: Block-level CRC checks