Re: Dropped table, no backup, restore from file system backup or WAL files?

I changed the recovery.conf file so it has one statement:

restore_command = 'copy D:\devj\WCSD\received\pg_xlog\%f %p'

This is what I now get in pg_log:

LOG: database system was shut down at 2010-07-07 14:48:34 EDT
LOG: starting archive recovery
LOG: restore_command = 'copy D:\devj\WCSD\received\pg_xlog\%f %p'
LOG: could not open file "pg_xlog/0000000700000000000000BE" (log file 0, segment 190): No such file or directory
LOG: invalid primary checkpoint record
LOG: could not open file "pg_xlog/0000000700000000000000BE" (log file 0, segment 190): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record

And as before, nothing is restored.

These are the "archived" files:

0000000100000000000000B6
0000000100000000000000B7
0000000100000000000000B8
0000000100000000000000B9
0000000100000000000000BA
0000000100000000000000BB
0000000100000000000000BC

It's looking for timeline 7 but the timeline of the archived files is 1. (Big deal, I can rename them.)

It's also looking for file BE, but the files are B6 through BC.

I also tried with this: restore_command = 'copy D:\devj\WCSD\received\%f %p'

John

On Wed, 07 Jul 2010 06:33:01 +0200, Jesper Krogh wrote:

>On 2010-07-07 03:24, John T. Dow wrote:
>In neither case does it restore any data.
>
>> Note: for the recovery procedure, I have a BAT file that literally does nothing. The reason is that I've copied the proper WAL files into the pg_xlog directory, so there is no archiving per se
>Ok, try to fix that.. as per:
>24.3.3 here:
>http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html
>
>Assuming that the filesystem backup was made using
>pg_start_backup()/pg_stop_backup() it will just work.
>
>--
>Jesper