Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 6A10B633952
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 17:35:18 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 13820-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 17:35:12 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14])
	by mail.postgresql.org (Postfix) with ESMTP id B481D6326B5
	for <pgsql-admin@postgresql.org>; Wed,  4 Mar 2009 17:35:02 -0400 (AST)
Received: by locust.cns.vt.edu (Postfix, from userid 986)
	id 7F980118DD6; Wed,  4 Mar 2009 16:35:00 -0500 (EST)
Date: Wed, 4 Mar 2009 16:35:00 -0500
From: Ray Stell <stellr@cns.vt.edu>
To: Yauheni Labko <yyl@chappy.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: standby waiting for what?
Message-ID: <20090304213500.GE25611@cns.vt.edu>
References: <20090304200612.GA25611@cns.vt.edu>
	<20090304201451.GB25611@cns.vt.edu>
	<200903041541.06149.yyl@chappy.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200903041541.06149.yyl@chappy.com>
User-Agent: Mutt/1.5.17 (2007-11-01)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/59
X-Sequence-Number: 31559

On Wed, Mar 04, 2009 at 03:41:06PM -0500, Yauheni Labko wrote:
> For some reason it is looking for 00000002000000000000001C.00512178.backup 
> file which is not the WAL file.
>  
> Are you sure that you made initial recovery properly?

I could have fouled this in any number of ways.  Like I said
I'm trying to understand how to analyze the situation and maybe
learn something.

OK, so my recovery.conf is set like this:

restore_command='/usr/local/pgsql/bin/pg_standby  /data/pgsql/wals/alerts_oamp %f %p %r >> /home/postgresql/log/alerts_oamp/recovery.log'

So, the %f arg sent to the pg_standby command has a value of
00000002000000000000001C.00512178.backup, right?  Is that wrong?
If so, where could that have come from or how could I have trashed
the thing.  

I love fishing.