Search Postgresql Archives

How to restore my database ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 R. - Axcenteo

 

__________________________________
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

 

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux