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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954