On Tue, Jan 17, 2012 at 6:52 AM, Fujii Masao <masao.fu...@gmail.com> wrote: > On Mon, Jan 16, 2012 at 2:06 AM, Simon Riggs <si...@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.
Oh, I did have NUM_AUXILIARY_PROCS increased at one point, but I "realised" it wasn't needed and removed it. Will change that. Thanks. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers