Re: Wierd quirk of HS/SR, probably not fixable - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Wierd quirk of HS/SR, probably not fixable
Date
Msg-id 4BD6FD97.3050507@enterprisedb.com
Whole thread Raw
In response to Re: Wierd quirk of HS/SR, probably not fixable  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas wrote:
> On Tue, Apr 27, 2010 at 5:25 AM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> Yep. I've committed a patch to do that.
> 
> Is there no way for the slave to recover from this situation?

No, it will never open up for hot standby, and it will error at the end
of recovery anyway. This just makes it happen earlier and with a smarter
error message.

In theory, if the data directory was fully copied by the time of the
shutdown/crash and the only thing that was missing was pg_stop_backup(),
all the data is there, so you could get a consistent database. But we
can't know if it's consistent or not, so we don't allow it.

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


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Differential backup
Next
From: "Kevin Grittner"
Date:
Subject: Re: Differential backup