From: Ray Stell <stellr@cns.vt.edu>
To: Yauheni Labko <yyl@chappy.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: standby waiting for what?
Date: Wed, 4 Mar 2009 16:35:00 -0500
Message-ID: <20090304213500.GE25611@cns.vt.edu> (raw)
In-Reply-To: <200903041541.06149.yyl@chappy.com>
References: <20090304200612.GA25611@cns.vt.edu>
<20090304201451.GB25611@cns.vt.edu>
<200903041541.06149.yyl@chappy.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu, yyl@chappy.com
Subject: Re: standby waiting for what?
In-Reply-To: <20090304213500.GE25611@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox