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: (view raw, whole thread or download thread mbox)
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.
> " %f %p"

Just use PITRTools. Your life will be easier.


-- Major Contributor
Command Prompt, Inc: - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering |

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-2017 The PostgreSQL Global Development Group