Обсуждение: WAL restore
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
Office 408-907-9310
Cell 408 429 0627
55 SouthMarket Street
San Jose, CA 95113
Вложения
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
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