I am trying to put my database in recovery mode and I get the following error:
===========
LOG: starting archive recovery
LOG: restore_command = "/myrestore/pg_restore.sh %f %p"
00000001.history pg_xlog/RECOVERYHISTORY
[Main]: Server requested for 00000001.history to be copied to
pg_xlog/RECOVERYHISTORY
[pg_restore::isWALFileReady]: 1 Available WAL Files
[Main]: Request to copy 00000001.history to pg_xlog/RECOVERYHISTORY
[pg_restore]::copyWALFile: Moving
/mybackup/000000010000000000000001.009352E8.backup to
pg_xlog/RECOVERYHISTORY
LOG: restored log file "00000001.history" from archive
FATAL: syntax error in history file: START WAL LOCATION: 0/19352E8
(file 000000010000000000000001)
HINT: Expected a numeric timeline ID.
LOG: startup process (PID 12323) exited with exit code 1
LOG: aborting startup due to startup process failure
===========
In the log above, the logs with [Main] or [pg_restore] is my script
which is called by the recovery.conf.
The postgres server is asking for 00000001.history file and I do not
have that file. All I have is the 0*10*1.009352E8.backup file and
other WAL files starting from 0*10*1. In the above case, I move
0*10*1.009352E8.backup pg_xlog/RECOVERYHISTORY. Note that my backup is
on a staging area and I can therefore move safely.
What am I doing wrong?
If I indicate that I do not have the concerned file by returning error
code 1, I get the following error in the log:
============
LOG: starting archive recovery
LOG: restore_command = "/myrestore/pg_restore.sh %f %p"
00000001.history pg_xlog/RECOVERYHISTORY
[Main]: Server requested for 00000001.history to be copied to
pg_xlog/RECOVERYHISTORY
00000001000000000000004F pg_xlog/RECOVERYXLOG
[Main]: Server requested for 00000001000000000000004F to be copied to
pg_xlog/RECOVERYXLOG
LOG: could not open file "pg_xlog/00000001000000000000004F" (log file
0, segment 79): No such file or directory
LOG: invalid primary checkpoint record
00000001000000000000004F pg_xlog/RECOVERYXLOG
[Main]: Server requested for 00000001000000000000004F to be copied to
pg_xlog/RECOVERYXLOG
LOG: could not open file "pg_xlog/00000001000000000000004F" (log file
0, segment 79): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 12222) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was shut down at 2007-03-19 03:33:05 PDT
==============
So what am I doing wrong here? Any help in the above matter is greatly
appreciated.
Regards
Dhaval