From: Yauheni Labko <yyl@chappy.com>
Reply-To: yyl@chappy.com
Organization: Chapdelaine & Co
To: pgsql-admin@postgresql.org
Subject: Re: standby waiting for what?
Date: Wed, 4 Mar 2009 17:05:19 -0500
User-Agent: KMail/1.9.9
References: <20090304200612.GA25611@cns.vt.edu>
	<200903041541.06149.yyl@chappy.com>
	<20090304213500.GE25611@cns.vt.edu>
In-Reply-To: <20090304213500.GE25611@cns.vt.edu>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200903041705.19794.yyl@chappy.com>

No. %f is the WAL filename which is needed by the server to start recovery.  
00000002000000000000001C.00512178.backup will give you start and end of WAL 
segment, the WAL filename containing this segment and your label to identify 
where it might be. That's why I asked you about your backup.

What is the archive_command for primary server?


Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine & Co.
(212)208-9150


On Wednesday 04 March 2009 04:35:00 pm you wrote:
> 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.