On Fri, Jan 27, 2012 at 12:50 AM, Magnus Hagander <mag...@hagander.net> wrote: >> One idea; starting archive recovery with standby_mode=on meets your needs? > > I haven't tested, but probably, yes. But in that case, why do we need > the pause_at_recovery_target *at all*? It's basically overloaded > functionality already, but I figured it was set up that way to keep > replication and recovery a bit separated?
AFAIK, when standby_mode = on, archive recovery pauses only at end of WAL files. When recovery target is specified and archive recovery reaches the target, it doesn't pause. OTOH, when pause_at_recovery_target is set, archive recovery pauses only at the target but not end of WAL files. Neither can cover all the usecases. So pause_at_recovery_target was implemented. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers