I am trying to setup recovery from WAL, recovery is done properly but there are some alerting messages in the log file
log file :
*********************************************************************************************
2007-11-27 14:08:04 IST LOG: database system was interrupted at 2007-11-27 13:59:44 IST
2007-11-27 14:08:04 IST LOG: starting archive recovery
2007-11-27 14:08:04 IST LOG: restore_command = "cp /mnt/server/archivedir/%f %p"
cp: cannot stat `/mnt/server/archivedir/00000001.history': No such file or directory
2007-11-27 14:08:04 IST LOG: restored log file "000000010000000000000053.00000020.backup" from archive
2007-11-27 14:08:05 IST LOG: restored log file "000000010000000000000053" from archive
2007-11-27 14:08:05 IST LOG: checkpoint record is at 0/53000020
2007-11-27 14:08:05 IST LOG: redo record is at 0/53000020; undo record is at 0/0; shutdown FALSE
2007-11-27 14:08:05 IST LOG: next transaction ID: 0/13326; next OID: 69934
2007-11-27 14:08:05 IST LOG: next MultiXactId: 1; next MultiXactOffset: 0
2007-11-27 14:08:05 IST LOG: automatic recovery in progress
2007-11-27 14:08:05 IST LOG: redo starts at 0/53000070
2007-11-27 14:08:06 IST LOG: restored log file "000000010000000000000054" from archive
2007-11-27 14:08:06 IST LOG: restored log file "000000010000000000000055" from archive
2007-11-27 14:08:07 IST LOG: restored log file "000000010000000000000056" from archive
cp: cannot stat `/mnt/server/archivedir/000000010000000000000057': No such file or directory
2007-11-27 14:08:07 IST LOG: record with zero length at 0/57000070
2007-11-27 14:08:07 IST LOG: redo done at 0/57000020
cp: cannot stat `/mnt/server/archivedir/000000010000000000000057': No such file or directory
2007-11-27 14:08:07 IST LOG: archive recovery complete
2007-11-27 14:08:08 IST LOG: database system is ready
2007-11-27 14:08:18 IST LOG: archived transaction log file "000000010000000000000057"
**********************************************************************************************
from above log it seems that server is looking for 00000001.history which is not there , but this file is not created by the server insted it created 00000001.backup (which document also suggest is the history file)
Should i ignore this message?
Secondly,
output from 00000001.backup file:
******************************************************************************************
START WAL LOCATION: 0/53000020 (file 000000010000000000000053)
STOP WAL LOCATION: 0/54000000 (file 000000010000000000000054)
CHECKPOINT LOCATION: 0/53000020
START TIME: 2007-11-27 13:59:44 IST
LABEL: /mnt/server/base_backup/20071127
STOP TIME: 2007-11-27 14:00:09 IST
*******************************************************************************************
last WAL when server was shut down was 000000010000000000000059
and file upto 000000010000000000000056 where archived.
I copied WAL 000000010000000000000057,000000010000000000000058 ,000000010000000000000059 to another location.
removed the data directory and restored the same from base backup, cleaned the pg_xlog and kept WAL 000000010000000000000057,000000010000000000000058 ,000000010000000000000059 in it.
Now from log it can be seen warning for WAL 000000010000000000000057
Can anybody please explain me wht is going wrong?
JUST for note:recover was complete.
Thanks in advance
With regards
Ashish...
Find a mall, hotel or ATM in any part of India. Click here.
