2011/7/4 Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>:
>
>> When the standby restarts after it crashes during recovery, it always
>> checks whether recovery has reached the backup end location by
>> using minRecoveryPoint even though the standby doesn't start from
>> the backup. This looks odd.
>
> Certainly.
>
> But, in this case, the state before recovery starts is lost.
> Therefore, postgres can not see that the backup got from whether
> standby server or master.
>
> What should?
> Should use pg_control?
> Ex.
> * Add 'Where to get backup' to pg_control. (default 'none')
> * When recovery starts, it checks it whether 'none'.
> * When minRecoveryPoint equals 0/0, change 'master'.
> * When minRecoveryPoint do not equals 0/0, change 'slave'.
> * When it reached the end of recovery, change 'none' .
What about using backupStartPoint to check whether this recovery
started from the backup or not?
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center