Re: problem with WAL files

Romain,

This is a problem I ran into during testing as well.  It seems that your base
backup must also include the in use wal file.  IN your case:
00000001000000000000000B.  So, I think the restore documentation is slightly
misleading. In my experience, what you really need to do is remove all wal
files from your pg_xlog directory, then put in the in use wal file from when
you did your base backup (00000001000000000000000B in your case), put in the
recovery.conf and then start postgresql.  This procedure works well for me,
but I didn't quite grasp that initially when reading the documentation on how
to backup/restore with PITR.

On Thu, 30 Jun 2005, Romain Thouvenin wrote:

> But when I put the recovery.conf file and try to start postgres, it fails.
> The log file says :
>
> 2005-06-30 17:57:50 LOG:  could not open file "C:/Program
> Files/PostgreSQL/8.0/data/pg_xlog/00000001000000000000000B" (log file 0,
> segment 11): No such file or directory

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