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

From Simon Riggs
Subject Re: WAL Restore process during recovery
Date
Msg-id CA+U5nMJ+Q-dk1CnTabOrj+ZTg3Xr9Lu=qjFKM-ajpgPv0nPqMw@mail.gmail.com
Whole thread Raw
In response to Re: WAL Restore process during recovery  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: WAL Restore process during recovery
List pgsql-hackers
On Tue, Jan 17, 2012 at 6:52 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> 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

Fixed and better documented.

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

Not sure exactly what you mean, but I fixed a bug that might be
something you're seeing.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Vacuum rate limit in KBps
Next
From: Robert Haas
Date:
Subject: Re: logging in high performance systems.