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

From Heikki Linnakangas
Subject Re: Backup history file should be replicated in Streaming Replication?
Date
Msg-id 4B0E39A0.1060205@enterprisedb.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?
List pgsql-hackers
Fujii Masao wrote:
> On Thu, Nov 26, 2009 at 4:55 PM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> Fujii Masao wrote:
>>> In current SR, since a backup history file is not replicated,
>>> the standby always starts an archive recovery without a backup
>>> history file, and a wrong minRecoveryPoint might be used. This
>>> is not a problem for SR itself, but would cause trouble when
>>> SR cooperates with Hot Standby.
>> But the backup history file is included in the base backup you start
>> replication from, right?
> 
> No. A backup history file is created by pg_stop_backup().
> So it's not included in the base backup.

Ah, I see.

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.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Backup history file should be replicated in Streaming Replication?
Next
From: Fujii Masao
Date:
Subject: Re: Backup history file should be replicated in Streaming Replication?