Re: 9.2.3 crashes during archive recovery

Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> writes:
> On 13.02.2013 21:21, Tom Lane wrote:
>> It would only be broken if someone interrupted a crash recovery
>> mid-flight and tried to establish a recovery stop point before the end
>> of WAL, no? Why don't we just forbid that case? This would either be
>> the same as, or a small extension of, the pg_control state vs existence
>> of recovery.conf error check that was just discussed.

> The problem is when you interrupt archive recovery (kill -9), and
> restart. After restart, the system needs to know how far the WAL was
> replayed before the crash, because it must not open for hot standby
> queries, or allow the database to be started up in master-mode, until
> it's replayed the WAL up to that same point again.

Well, archive recovery is a different scenario --- Simon was questioning
whether we need a minRecoveryPoint mechanism in crash recovery, or at
least that's what I thought he asked.

regards, tom lane