pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWAL restore
3+ messages / 2 participants
[nested] [flat]
* WAL restore
@ 2007-06-07 06:31 Jerry Huff <jerry.huff@iloopmobile.com>
2007-06-07 07:50 ` Re: WAL restore Simon Riggs <simon@2ndquadrant.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 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 ` Re: WAL restore Simon Riggs <simon@2ndquadrant.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 06:31 WAL restore Jerry Huff <jerry.huff@iloopmobile.com>
2007-06-07 07:50 ` Re: WAL restore Simon Riggs <simon@2ndquadrant.com>
@ 2007-06-07 08:19 ` 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