Re: 8.2 "real-time" recovery

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Dragos Valentin Moinescu <dragos(dot)moinescu(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.2 "real-time" recovery
Date: 2010-08-25 19:47:57
Message-ID: 1282765677.11634.325.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-08-25 19:49:05 Re: 8.2 "real-time" recovery
Previous Message Dragos Valentin Moinescu 2010-08-25 19:39:38 Re: 8.2 "real-time" recovery