Re: Dropped table, no backup, restore from file system backup or WAL files? - Mailing list pgsql-novice

From John T. Dow
Subject Re: Dropped table, no backup, restore from file system backup or WAL files?
Date
Msg-id 201007071918.o67JInBG018124@web7.nidhog.com
Whole thread Raw
In response to Dropped table, no backup, restore from file system backup or WAL files?  ("John T. Dow" <john@johntdow.com>)
List pgsql-novice
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
properWAL 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





pgsql-novice by date:

Previous
From: Greg
Date:
Subject: Re: Data type OIDs
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: how to extract and use a string like a constraint?