Re: upgrade proc with pitr standby

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Devrim G?ND?Z <devrim(at)gunduz(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: upgrade proc with pitr standby
Date: 2010-05-13 16:04:23
Message-ID: 20100513160423.GI22313@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 13, 2010 at 09:31:27AM -0500, Kevin Grittner wrote:
> Ray Stell <stellr(at)cns(dot)vt(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc G. Fournier 2010-05-13 18:05:38 Re: List traffic
Previous Message Kevin Grittner 2010-05-13 14:31:27 Re: upgrade proc with pitr standby