[mitsu-ko@localhost postgresql-9.2.3]$ [Master] 2013-04-30 23:23:38 EDT LOG: 00000: database system was shut down in recovery at 2013-04-30 22:38:11 EDT [Master] 2013-04-30 23:23:38 EDT LOCATION: StartupXLOG, xlog.c:6207 000000010000000000000002 archive_status [Master] 2013-04-30 23:23:41 EDT LOG: 00000: restored log file "00000002.history" from archive [Master] 2013-04-30 23:23:41 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 000000010000000000000002 archive_status [Master] 2013-04-30 23:23:44 EDT LOG: 00000: restored log file "00000003.history" from archive [Master] 2013-04-30 23:23:44 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 000000010000000000000002 archive_status [Master] 2013-04-30 23:23:47 EDT LOG: 00000: restored log file "00000004.history" from archive [Master] 2013-04-30 23:23:47 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 000000010000000000000002 archive_status [Master] 2013-04-30 23:23:50 EDT LOG: 00000: restored log file "00000005.history" from archive [Master] 2013-04-30 23:23:50 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 000000010000000000000002 archive_status cp: cannot stat `../arc/00000006.history': File is missing 000000010000000000000002 archive_status [Master] 2013-04-30 23:23:56 EDT LOG: 00000: restored log file "00000005.history" from archive [Master] 2013-04-30 23:23:56 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 [Master] 2013-04-30 23:23:56 EDT LOG: 00000: starting archive recovery [Master] 2013-04-30 23:23:56 EDT LOCATION: StartupXLOG, xlog.c:6308 000000010000000000000002 00000005.history archive_status cp: cannot stat `../arc/000000050000000000000002': File is missing 000000010000000000000002 00000005.history archive_status cp: cannot stat `../arc/000000040000000000000002': File is missing 000000010000000000000002 00000005.history archive_status cp: cannot stat `../arc/000000030000000000000002': File is missing 000000010000000000000002 00000005.history archive_status [Master] 2013-04-30 23:24:08 EDT LOG: 00000: restored log file "000000020000000000000002" from archive [Master] 2013-04-30 23:24:08 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 [Master] 2013-04-30 23:24:08 EDT LOG: 00000: redo starts at 0/2000020 [Master] 2013-04-30 23:24:08 EDT LOCATION: StartupXLOG, xlog.c:6715 [Master] 2013-04-30 23:24:08 EDT LOG: 00000: consistent recovery state reached at 0/3000000 [Master] 2013-04-30 23:24:08 EDT LOCATION: CheckRecoveryConsistency, xlog.c:7252 [Master] 2013-04-30 23:24:08 EDT LOG: 00000: database system is ready to accept read only connections [Master] 2013-04-30 23:24:08 EDT LOCATION: sigusr1_handler, postmaster.c:4272 000000010000000000000002 000000020000000000000002 00000005.history archive_status cp: cannot stat `../arc/000000050000000000000003': File is missing 000000010000000000000002 000000020000000000000002 00000005.history archive_status cp: cannot stat `../arc/000000040000000000000003': File is missing 000000010000000000000002 000000020000000000000002 00000005.history archive_status cp: cannot stat `../arc/000000030000000000000003': File is missing 000000010000000000000002 000000020000000000000002 00000005.history archive_status [Master] 2013-04-30 23:24:21 EDT LOG: 00000: restored log file "000000020000000000000003" from archive [Master] 2013-04-30 23:24:21 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 000000010000000000000002 000000020000000000000002 000000020000000000000003 00000005.history archive_status cp: cannot stat `../arc/000000050000000000000004': File is missing 000000010000000000000002 000000020000000000000002 000000020000000000000003 00000005.history archive_status cp: cannot stat `../arc/000000040000000000000004': File is missing 000000010000000000000002 000000020000000000000002 000000020000000000000003 00000005.history archive_status cp: cannot stat `../arc/000000030000000000000004': File is missing 000000010000000000000002 000000020000000000000002 000000020000000000000003 00000005.history archive_status [Master] 2013-04-30 23:24:33 EDT LOG: 00000: restored log file "000000020000000000000004" from archive [Master] 2013-04-30 23:24:33 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 [Master] 2013-04-30 23:24:33 EDT LOG: 00000: contrecord is requested by 0/4000020 [Master] 2013-04-30 23:24:33 EDT LOCATION: ReadRecord, xlog.c:4027 [Master] 2013-04-30 23:24:33 EDT LOG: 00000: redo done at 0/3000080 [Master] 2013-04-30 23:24:33 EDT LOCATION: StartupXLOG, xlog.c:6852 000000010000000000000002 000000020000000000000002 000000020000000000000003 000000020000000000000004 00000005.history archive_status cp: cannot stat `../arc/000000050000000000000003': File is missing 000000010000000000000002 000000020000000000000002 000000020000000000000003 000000020000000000000004 00000005.history archive_status cp: cannot stat `../arc/000000040000000000000003': File is missing 000000010000000000000002 000000020000000000000002 000000020000000000000003 000000020000000000000004 00000005.history archive_status cp: cannot stat `../arc/000000030000000000000003': File is missing 000000010000000000000002 000000020000000000000002 000000020000000000000003 000000020000000000000004 00000005.history archive_status [Master] 2013-04-30 23:24:45 EDT LOG: 00000: restored log file "000000020000000000000003" from archive [Master] 2013-04-30 23:24:45 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 000000010000000000000002 000000020000000000000002 000000020000000000000003 000000020000000000000004 00000005.history archive_status cp: cannot stat `../arc/00000006.history': File is missing [Master] 2013-04-30 23:24:48 EDT LOG: 00000: selected new timeline ID: 6 [Master] 2013-04-30 23:24:48 EDT LOCATION: StartupXLOG, xlog.c:6958 000000010000000000000002 000000020000000000000002 000000020000000000000003 000000020000000000000004 00000005.history archive_status xlogtemp.24906 [Master] 2013-04-30 23:24:51 EDT LOG: 00000: restored log file "00000005.history" from archive [Master] 2013-04-30 23:24:51 EDT LOCATION: RestoreArchivedFile, xlog.c:3259 [Master] 2013-04-30 23:24:51 EDT LOG: 00000: archive recovery complete [Master] 2013-04-30 23:24:51 EDT LOCATION: exitArchiveRecovery, xlog.c:5796 [Master] 2013-04-30 23:24:51 EDT LOG: 00000: checkpoint starting: end-of-recovery immediate wait [Master] 2013-04-30 23:24:51 EDT LOCATION: LogCheckpointStart, xlog.c:7717 [Master] 2013-04-30 23:24:51 EDT LOG: 00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.175 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-30 23:24:51 EDT LOCATION: LogCheckpointEnd, xlog.c:7805 [Master] 2013-04-30 23:24:51 EDT LOG: 00000: database system is ready to accept connections [Master] 2013-04-30 23:24:51 EDT LOCATION: reaper, postmaster.c:2408 [Master] 2013-04-30 23:24:51 EDT LOG: 00000: autovacuum launcher started [Master] 2013-04-30 23:24:51 EDT LOCATION: AutoVacLauncherMain, autovacuum.c:407 [mitsu-ko@localhost postgresql-9.2.3]$ ls Master/pg_xlog/ 000000010000000000000002 000000020000000000000002 000000020000000000000003 000000020000000000000004 00000005.history 00000006.history 000000060000000000000003 000000060000000000000004 archive_status [mitsu-ko@localhost postgresql-9.2.3]$ vim Master/pg_xlog/00000005.history [mitsu-ko@localhost postgresql-9.2.3]$ ls arc/ 000000010000000000000001 000000020000000000000005 00000002000000000000000C 000000020000000000000013 00000002000000000000001A 000000020000000000000021 000000020000000000000028 00000004000000000000002B 000000010000000000000002 000000020000000000000006 00000002000000000000000D 000000020000000000000014 00000002000000000000001B 000000020000000000000022 000000020000000000000029 00000005.history 000000010000000000000002.00000020.backup 000000020000000000000007 00000002000000000000000E 000000020000000000000015 00000002000000000000001C 000000020000000000000023 00000002000000000000002A 00000005000000000000002B 00000002.history 000000020000000000000008 00000002000000000000000F 000000020000000000000016 00000002000000000000001D 000000020000000000000024 00000003.history 00000005000000000000002C 000000020000000000000002 000000020000000000000009 000000020000000000000010 000000020000000000000017 00000002000000000000001E 000000020000000000000025 00000003000000000000002A 00000006.history 000000020000000000000003 00000002000000000000000A 000000020000000000000011 000000020000000000000018 00000002000000000000001F 000000020000000000000026 00000004.history 000000020000000000000004 00000002000000000000000B 000000020000000000000012 000000020000000000000019 000000020000000000000020 000000020000000000000027 00000004000000000000002A