Re: 8.2 "real-time" recovery - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: 8.2 "real-time" recovery
Date
Msg-id 1282765677.11634.325.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: 8.2 "real-time" recovery  (Dragos Valentin Moinescu <dragos.moinescu@gmail.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Fábio Gibon - Comex System
Date:
Subject: Re: PostgreSQL 8.4 x Win 2008 - slow connection
Next
From: Kieren Scott
Date:
Subject: Persistent server stats collection