Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2010-08-25 19:49:05
Subject: Re: 8.2 "real-time" recovery
Previous:From: Dragos Valentin MoinescuDate: 2010-08-25 19:39:38
Subject: Re: 8.2 "real-time" recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group