Re: pg_standby error - can't find 00000001.history

Eric Soroos <eric-psql(at)soroos(dot)net> writes:
> 2009-03-12 13:40:18 PDT LOG: starting archive recovery
> 2009-03-12 13:40:18 PDT LOG: restore_command = "/usr/lib/postgresql/
> 8.2/bin/pg_standby -l -d -k 100 -r 2 -s 2 -w 0 -t /tmp/pgsql.trigger.
> 5432 /data/pg/repl-db3 %f %p 2>> standby.log"
> 2009-03-12 13:40:18 PDT FATAL: could not restore file
> "00000001.history" from archive: return code 32512
> 2009-03-12 13:40:18 PDT LOG: startup process (PID 6223) exited with
> exit code 1

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

This seems to square with the above conclusion.

> 2) What file is not found? It sorta looks like the pg_standby
> binary, but I'm not sure that I believe that.

Permissions problems on some containing directory, perhaps?

regards, tom lane