Brendan Duddridge <brendan@xxxxxxxxxxxxxx> 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
