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,
__________________________________
Franck Roubieu
froubieu@xxxxxxxxxxxx
tel : 08 74 59 20 20 (tarif d'un appel local)
port : 06 12 58 80 62
-------------------------------------------------
AXCENTEO
Cap Alpha - Av. de L'Europe
34 940 Montpellier Cedex 9
----------------------------------------------
www.axcenteo.com
www.eo-demo.com
