Peter Eisentraut wrote:
> Simon Riggs wrote:
>> Recovery doesn't have a test framework as yet.
>
> I have been having these concerns as well. In fact, I recall
> discussions at least 8 years back about how pg_dump doesn't really have
> any organized testing, and we also have little regular testing of PITR
> aside from specific exercises that users or developers occasionally run.
>
> The question remains how to do it.
A very simple way to start would be to stop emitting shutdown
checkpoints. This would mean that any server restart would cause
recovery. This wouldn't be exhaustive, but enough people doing that
should cause at least some bugs to emerge.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support