Re: upgrade proc with pitr standby - Mailing list pgsql-admin

From Ray Stell
Subject Re: upgrade proc with pitr standby
Date
Msg-id 20100513160423.GI22313@cns.vt.edu
Whole thread Raw
In response to Re: upgrade proc with pitr standby  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
On Thu, May 13, 2010 at 09:31:27AM -0500, Kevin Grittner wrote:
> Ray Stell <stellr@cns.vt.edu> wrote:
> > ,3440,,2010-05-13 09:06:35.734 EDT,4bebf95b.d70,5,2010-05-13
> > 09:06:35 EDT,0,FATAL:  could not restore file "00000002.history"
> > from archive: return code 32512
>
> Return code 32512?  I think you'd be OK if your recovery script
> returned 1 when it didn't find this file.


Tom wrote last year:

Hmm ... 32512 is 0x7F00, which I think means exit(127), which is
generally what the shell returns when it can't find the program
it's supposed to execute.

> sh: /usr/lib/postgresql/8.2/bin/pg_standby: not found
> sh: /usr/lib/postgresql/8.2/bin/pg_standby: not found
> sh: /usr/lib/postgresql/8.2/bin/pg_standby: not found
> sh: /usr/lib/postgresql/8.2/bin/pg_standby: not found

duh.  measure twice, cut once.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: upgrade proc with pitr standby
Next
From: "Plugge, Joe R."
Date:
Subject: Slony-I - Update trigger on a replicated table