Re: Hot standby, recovery infra

On Sat, 2009-01-31 at 22:32 +0200, Heikki Linnakangas wrote:

> If you poison your WAL archive with a XLOG_CRASH_RECOVERY record, 
> recovery will never be able to proceed over that point. There would have 
> to be a switch to ignore those records, at the very least.

Definitely in assert mode only.

I'll do it as a test patch and keep it separate from main line.

> You don't really need to do it with a new WAL record. You could just add 
> a GUC or recovery.conf option along the lines of recovery_target: 
> crash_target=0/123456, and check for that in ReadRecord or wherever you 
> want the crash to occur.

Knowing that LSN is somewhat harder

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support