Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id E009963225F
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 16:48:10 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 66878-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Aug 2010 19:48:02 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 63272632BEF
	for <pgsql-admin@postgresql.org>; Wed, 25 Aug 2010 16:48:03 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by spinlock.commandprompt.com (Postfix) with ESMTP id B833B348038;
	Wed, 25 Aug 2010 12:48:01 -0700 (PDT)
X-Virus-Scanned: Debian amavisd-new at commandprompt.com
Received: from spinlock.commandprompt.com ([127.0.0.1])
	by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1])
	(amavisd-new, port 10024)
	with ESMTP id QDVaBEmlevqv; Wed, 25 Aug 2010 12:47:58 -0700 (PDT)
Received: from [192.168.1.132] (unknown [75.142.155.118])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id 834FA348002;
	Wed, 25 Aug 2010 12:47:58 -0700 (PDT)
Subject: Re: 8.2 "real-time" recovery
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: Dragos Valentin Moinescu <dragos.moinescu@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-admin@postgresql.org
In-Reply-To: <AANLkTimR=QjOgd2g3d6ahTepcbf=y6rzF+FR7Pg-cOwP@mail.gmail.com>
References: <AANLkTikat4MFkL7tidT-c4Sd0=FAYpNRX260MGt7fJs6@mail.gmail.com>
	<4C74DB180200002500034B6F@gw.wicourts.gov>
	<AANLkTikrtDP+nHwzqfPNB0VOuGSnGg_3kN9QxTTpGrD5@mail.gmail.com>
	<4C74DEE90200002500034B7A@gw.wicourts.gov>
	<AANLkTikmM__F+ewjEza33iRdLuiCp3z9Ru6OsXQF0TvC@mail.gmail.com>
	<4C74EC500200002500034B81@gw.wicourts.gov>
	<AANLkTimR=QjOgd2g3d6ahTepcbf=y6rzF+FR7Pg-cOwP@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Organization: Command Prompt, Inc.
Date: Wed, 25 Aug 2010 12:47:57 -0700
Message-ID: <1282765677.11634.325.camel@jd-desktop.unknown.charter.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.3 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201008/225
X-Sequence-Number: 35474

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