postgres_restores.log

2014-07-03 17:57:11 CEST LOG:  database system was interrupted; last known up at 2014-07-03 16:15:27 CEST
2014-07-03 17:57:11 CEST LOG:  starting point-in-time recovery to 2014-07-03 17:00:00+02
wal_e.operator.backup INFO     MSG: begin wal restore
        STRUCTURED: time=2014-07-03T15:57:11.798960-00 pid=11678 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/00000007.history.lzo prefix=lohap1/ seg=00000007.history state=begin
2014-07-03 17:57:12 CEST LOG:  incomplete startup packet
wal_e.blobstore.s3.s3_util INFO     MSG: completed download and decompression
        DETAIL: Downloaded and decompressed "s3://apsl-wale/lohap1/wal_005/00000007.history.lzo" to "pg_xlog/RECOVERYHISTORY"
        STRUCTURED: time=2014-07-03T15:57:12.225174-00 pid=11678
wal_e.operator.backup INFO     MSG: complete wal restore
        STRUCTURED: time=2014-07-03T15:57:12.227431-00 pid=11678 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/00000007.history.lzo prefix=lohap1/ seg=00000007.history state=complete
2014-07-03 17:57:12 CEST LOG:  restored log file "00000007.history" from archive
wal_e.operator.backup INFO     MSG: begin wal restore
        STRUCTURED: time=2014-07-03T15:57:12.339602-00 pid=11701 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000046.lzo prefix=lohap1/ seg=000000070000008100000046 state=begin
2014-07-03 17:57:12 CEST FATAL:  the database system is starting up
wal_e.blobstore.s3.s3_util INFO     MSG: completed download and decompression
        DETAIL: Downloaded and decompressed "s3://apsl-wale/lohap1/wal_005/000000070000008100000046.lzo" to "pg_xlog/RECOVERYXLOG"
        STRUCTURED: time=2014-07-03T15:57:12.906891-00 pid=11701
wal_e.operator.backup INFO     MSG: complete wal restore
        STRUCTURED: time=2014-07-03T15:57:12.909403-00 pid=11701 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000046.lzo prefix=lohap1/ seg=000000070000008100000046 state=complete
2014-07-03 17:57:12 CEST LOG:  restored log file "000000070000008100000046" from archive
2014-07-03 17:57:12 CEST LOG:  redo starts at 81/46000028
2014-07-03 17:57:12 CEST LOG:  consistent recovery state reached at 81/460000F0
2014-07-03 17:57:12 CEST LOG:  database system is ready to accept read only connections
wal_e.operator.backup INFO     MSG: begin wal restore
        STRUCTURED: time=2014-07-03T15:57:13.049499-00 pid=11727 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000047.lzo prefix=lohap1/ seg=000000070000008100000047 state=begin
wal_e.blobstore.s3.s3_util INFO     MSG: completed download and decompression
        DETAIL: Downloaded and decompressed "s3://apsl-wale/lohap1/wal_005/000000070000008100000047.lzo" to "pg_xlog/RECOVERYXLOG"
        STRUCTURED: time=2014-07-03T15:57:13.764389-00 pid=11727
wal_e.operator.backup INFO     MSG: complete wal restore
        STRUCTURED: time=2014-07-03T15:57:13.766897-00 pid=11727 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000047.lzo prefix=lohap1/ seg=000000070000008100000047 state=complete
2014-07-03 17:57:13 CEST LOG:  restored log file "000000070000008100000047" from archive
wal_e.operator.backup INFO     MSG: begin wal restore
        STRUCTURED: time=2014-07-03T15:57:13.936195-00 pid=11757 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000048.lzo prefix=lohap1/ seg=000000070000008100000048 state=begin
wal_e.blobstore.s3.s3_util INFO     MSG: completed download and decompression
        DETAIL: Downloaded and decompressed "s3://apsl-wale/lohap1/wal_005/000000070000008100000048.lzo" to "pg_xlog/RECOVERYXLOG"
        STRUCTURED: time=2014-07-03T15:57:14.555140-00 pid=11757
wal_e.operator.backup INFO     MSG: complete wal restore
        STRUCTURED: time=2014-07-03T15:57:14.557547-00 pid=11757 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000048.lzo prefix=lohap1/ seg=000000070000008100000048 state=complete
2014-07-03 17:57:14 CEST LOG:  restored log file "000000070000008100000048" from archive
wal_e.operator.backup INFO     MSG: begin wal restore
        STRUCTURED: time=2014-07-03T15:57:14.672820-00 pid=11770 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000049.lzo prefix=lohap1/ seg=000000070000008100000049 state=begin
wal_e.blobstore.s3.s3_util INFO     MSG: completed download and decompression
        DETAIL: Downloaded and decompressed "s3://apsl-wale/lohap1/wal_005/000000070000008100000049.lzo" to "pg_xlog/RECOVERYXLOG"
        STRUCTURED: time=2014-07-03T15:57:15.354238-00 pid=11770
wal_e.operator.backup INFO     MSG: complete wal restore
        STRUCTURED: time=2014-07-03T15:57:15.356340-00 pid=11770 action=wal-fetch key=s3://apsl-wale/lohap1/wal_005/000000070000008100000049.lzo prefix=lohap1/ seg=000000070000008100000049 state=complete
2014-07-03 17:57:15 CEST LOG:  restored log file "000000070000008100000049" from archive
2014-07-03 17:57:15 CEST LOG:  recovery stopping before commit of transaction 9438922, time 2014-07-03 17:00:00.213704+02
2014-07-03 17:57:15 CEST LOG:  recovery has paused
2014-07-03 17:57:15 CEST HINT:  Execute pg_xlog_replay_resume() to continue.