Re: WAL Restore process during recovery

On Mon, Jan 16, 2012 at 2:06 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> WALRestore process asynchronously executes restore_command while
> recovery continues working.
>
> Overlaps downloading of next WAL file to reduce time delays in file
> based archive recovery.
>
> Handles cases of file-only and streaming/file correctly.

Though I've not reviewed the patch deeply yet, I observed the following
two problems when I tested the patch.

When I set up streaming replication + archive (i.e., restore_command is set)
and started the standby, I got the following error:
   FATAL:  all AuxiliaryProcs are in use   LOG:  walrestore process (PID 18839) exited with exit code 1

When I started an archive recovery without setting restore_command,
it successfully finished.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center