How to restore my database ?

From: "Franck Roubieu - AXCENTEO" <froubieu(at)axcenteo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to restore my database ?
Date: 2007-08-27 12:50:00
Message-ID: 002e01c7e8a8$c817c820$0b00a8c0@biloneport
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)axcenteo(dot)com
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

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-08-27 12:55:56 Re: [ERROR] syntax error at end of input
Previous Message Alban Hertroys 2007-08-27 12:48:04 Re: SQL Diff ?