| From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
|---|---|
| To: | Yauheni Labko <yyl(at)chappy(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: standby waiting for what? |
| Date: | 2009-03-04 21:35:00 |
| Message-ID: | 20090304213500.GE25611@cns.vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carol Walter | 2009-03-04 21:40:10 | Re: Database in use? |
| Previous Message | Tom Lane | 2009-03-04 21:27:02 | Re: Postgressql backup/restore question |