pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
WAL restore
3+ messages / 2 participants
[nested] [flat]

* WAL restore
@ 2007-06-07 06:31  Jerry Huff <jerry.huff@iloopmobile.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Jerry Huff @ 2007-06-07 06:31 UTC (permalink / raw)
  To: 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

 

  

 

Attachments:

image001.jpg (image/jpeg, 3.1K) download view image
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: WAL restore
@ 2007-06-07 07:50  Simon Riggs <simon@2ndquadrant.com>
  parent: Jerry Huff <jerry.huff@iloopmobile.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Simon Riggs @ 2007-06-07 07:50 UTC (permalink / raw)
  To: Jerry Huff <jerry.huff@iloopmobile.com>; +Cc: pgsql-admin

On Wed, 2007-06-06 at 23:31 -0700, Jerry Huff wrote:
> 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.

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

Please send the history file, plus give your best understanding of the
previous history of this database's crashes/recoveries.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: WAL restore
@ 2007-06-07 08:19  Simon Riggs <simon@2ndquadrant.com>
  parent: Simon Riggs <simon@2ndquadrant.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Simon Riggs @ 2007-06-07 08:19 UTC (permalink / raw)
  To: Jerry Huff <jerry.huff@iloopmobile.com>; +Cc: pgsql-admin

On Thu, 2007-06-07 at 08:50 +0100, Simon Riggs wrote:
> On Wed, 2007-06-06 at 23:31 -0700, Jerry Huff wrote:
> > 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.
> 
> > PANIC:  syntax error in history file: START WAL LOCATION: 2/5DC04228
> > (file 00000001000000020000005D)
> 
> Please send the history file, plus give your best understanding of the
> previous history of this database's crashes/recoveries.

AFAICS the .history contains the same contents as a normal .backup file
would. Which is a little strange, so its either a definite bug or you're
manually editing/manipulating file contents, which is unlikely to
succeed.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com





^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-06-07 08:19 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-07 06:31 WAL restore Jerry Huff <jerry.huff@iloopmobile.com>
2007-06-07 07:50 ` Simon Riggs <simon@2ndquadrant.com>
2007-06-07 08:19   ` Simon Riggs <simon@2ndquadrant.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox