Hello, We tried many things but didnt 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 R. - Axcenteo __________________________________ Franck Roubieu [EMAIL PROTECTED] 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 <http://www.eo-demo.coim> www.expresseo.com
