WAL restore - Mailing list pgsql-admin

From Jerry Huff
Subject WAL restore
Date
Msg-id E7A33F300091E54CA0D5FA2AD8C565D6028BB3F6@EXCH01.iloopmobile.com
Whole thread Raw
Responses Re: WAL restore
List 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

Office 408-907-9310

Cell 408 429 0627

55 SouthMarket Street

San Jose, CA 95113

 

 cid:image001.jpg@01C7802B.CA30E6E0

 

Attachment

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: 8.2.4 Won't Build 8.1 Functional Indexes
Next
From: "Simon Riggs"
Date:
Subject: Re: WAL restore