Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Eric Soroos <eric-psql@xxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux