Search Postgresql Archives

cp: cannot stat `/mnt/server/archivedir/00000001.history': No such file or directory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello List Member,

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux