Thread: How to restore my database ?

Hello,

We tried many things but didn’t succeed.  

Our DB crashed without any recent backup.

We have 3 elements:
- a backup we did in February,
- 4 WAL files in the pg_xlog folder created in august,
- the “base” folder (in which there are table files created in august)

Q1 : Is it possible to copy (or modify) “base” folder files in order to restore  ?

Other solution: Wal files

Q2 : Is it possible to use a “restore_command” with these 4 WAL files and our February backup ? 

We have already tried editing the recovery.conf file:

restore_command = "copy C:\archives\0000000100000000000000BC "%p""

… But, we had this error message:

«
2007-08-24 16:32:55 LOG: database system was shut down at 2007-08-24 16:32:01 Paris, Madrid
2007-08-24 16:32:55 LOG: starting archive recovery
2007-08-24 16:32:55 LOG: restore_command = "copy C:\archives\0000000100000000000000BC "%p""
2007-08-24 16:32:56 LOG: restored log file "00000001.history" from archive
2007-08-24 16:32:56 PANIC: syntax error in history file: \Ð
2007-08-24 16:32:56 HINT: Expected a numeric timeline ID.
»

Note:  every WAL file begin by “\Д

Q3 : Do you know this error ?

thanks

Best regards

Cordialement,