Re: problem with WAL files

On Wed, 6 Jul 2005, Bruce Momjian wrote:

> That is strange.  You said it reported the file did not exist.  When the
> command fails, we assume it doesn't exist.  Not sure what else we can
> do.

I'm sorry, I should have copied and pasted the logs.  It did not report a
failure to copy from the archive dir, it reported that the wal file did not
exist in pg_xlog.  Here's a snip from the log:


Jul  5 22:14:06 db1 postgres[26299]: [1-1] LOG:  database system was interrupted
  at 2005-07-05 23:13:54 PDT
Jul  5 22:14:06 db1 postgres[26299]: [2-1] LOG:  starting archive recovery
Jul  5 22:14:06 db1 postgres[26299]: [3-1] LOG:  restore_command = "/usr/local/b
in/walrestore.sh %f %p"
Jul  5 22:14:06 db1 postgres[26299]: [4-1] LOG:  could not open file "/usr/local
/pgsql/data/pg_xlog/00000001000000060000005F" (log file 6, segment 95): No such
file or
Jul  5 22:14:06 db1 postgres[26299]: [4-2]  directory
Jul  5 22:14:06 db1 postgres[26299]: [5-1] LOG:  invalid checkpoint record
Jul  5 22:14:06 db1 postgres[26299]: [6-1] PANIC:  could not locate required
checkpoint record


--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954