From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Backup history file should be replicated in Streaming Replication? |
Date: | 2009-11-26 08:17:36 |
Message-ID: | 4B0E39A0.1060205@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Fujii Masao wrote:
> On Thu, Nov 26, 2009 at 4:55 PM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2009-11-26 08:20:43 | Re: Backup history file should be replicated in Streaming Replication? |
Previous Message | Fujii Masao | 2009-11-26 08:02:24 | Re: Backup history file should be replicated in Streaming Replication? |