WAL restore

From: "Jerry Huff" <jerry(dot)huff(at)iloopmobile(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: WAL restore
Date: 2007-06-07 06:31:46
Message-ID: E7A33F300091E54CA0D5FA2AD8C565D6028BB3F6@EXCH01.iloopmobile.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am having a problem in restoring from WAL files. I have restored from
a dump file and trying to step through the WAL files.

LOG: starting archive recovery

LOG: restore_command = "cp /home/backup/%f "%p""

LOG: restored log file "00000001.history" from archive

PANIC: syntax error in history file: START WAL LOCATION: 2/5DC04228
(file 00000001000000020000005D)

HINT: Expected a numeric timeline ID.

LOG: startup process (PID 8325) was terminated by signal 6

LOG: aborting startup due to startup process failure

...........................................................could not
start postmaster

Jerry Huff

Senior Systems Administrator

iLoopMobile

http://www.iloopmobile.com <http://www.iloopmobile.com/>

Office 408-907-9310

Cell 408 429 0627

55 SouthMarket Street

San Jose, CA 95113

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Charles.Hou 2007-06-07 07:07:03 Re: the right time to vacuum database?
Previous Message Joshua D. Drake 2007-06-07 04:35:39 Re: 8.2.4 Won't Build 8.1 Functional Indexes