From: Yauheni Labko <yyl@chappy.com>
To: pgsql-admin@postgresql.org
Subject: Re: standby waiting for what?
Date: Wed, 4 Mar 2009 17:05:19 -0500
Message-ID: <200903041705.19794.yyl@chappy.com> (raw)
In-Reply-To: <20090304213500.GE25611@cns.vt.edu>
References: <20090304200612.GA25611@cns.vt.edu>
<200903041541.06149.yyl@chappy.com>
<20090304213500.GE25611@cns.vt.edu>
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.
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: yyl@chappy.com
Subject: Re: standby waiting for what?
In-Reply-To: <200903041705.19794.yyl@chappy.com>
* 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