Re: Recovery will take 10 hours

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Brendan Duddridge <brendan(at)clickspace(dot)com> writes:
> However, as I just finished posting to the list, the process died  
> with a PANIC error:

> [2006-04-20 16:41:28 MDT] LOG: restored log file  
> "000000010000018F00000034" from archive
> [2006-04-20 16:41:35 MDT] LOG: restored log file  
> "000000010000018F00000035" from archive
> [2006-04-20 16:41:38 MDT] LOG: restored log file  
> "000000010000018F00000036" from archive
> sh: line 1: /wal_archive/000000010000018F00000037.gz: No such file or  
> directory
> [2006-04-20 16:41:46 MDT] LOG: could not open file "pg_xlog/ 
> 000000010000018F00000037" (log file 399, segment 55): No such file or  
> directory
> [2006-04-20 16:41:46 MDT] LOG: redo done at 18F/36FFF254
> sh: line 1: /wal_archive/000000010000018F00000036.gz: No such file or  
> directory
> [2006-04-20 16:41:46 MDT] PANIC: could not open file "pg_xlog/ 
> 000000010000018F00000036" (log file 399, segment 54): No such file or  
> directory

This looks to me like a bug in your archive restore command.  It had
just finished providing 000000010000018F00000036 at 16:41:38, why was
it not able to do so again at 16:41:46?

			regards, tom lane