Re: 8.2 "real-time" recovery

On Wed, 2010-08-25 at 22:39 +0300, Dragos Valentin Moinescu wrote:

> What I did in terms of warm standby:
> 1. base backup using rsync
> 2. rsync all wal files
> 3. edited recoverfy.conf with a recovery_command="cp /wal-archive/%f %p"
>
> So I need to write a new recovery_command that actually process any
> files from there, but waits for other files to arrive.
> "recovery-command.sh %f %p"

Just use PITRTools. Your life will be easier.

http://github.com/commandprompt/PITRTools

JD

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt