Re: WAL Restore process during recovery - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: WAL Restore process during recovery
Date
Msg-id CAHGQGwE_KHsgM_1reHHJo36WhmJqCa9LJarC45yQacuXEzwcJA@mail.gmail.com
Whole thread Raw
In response to WAL Restore process during recovery  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: WAL Restore process during recovery  (Simon Riggs <simon@2ndQuadrant.com>)
Re: WAL Restore process during recovery  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: Review: Non-inheritable check constraints
Next
From: Fujii Masao
Date:
Subject: Re: psql case preserving completion