Guest User

Untitled

a guest
Oct 15th, 2011
109
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. pg_start_backup
  2. -----------------
  3. D/C10000F8
  4. (1 row)
  5.  
  6. receiving incremental file list
  7. ./
  8. backup_label
  9. base/16411/12435
  10. base/16411/5876734
  11. base/5871025/
  12. ...
  13. base/5871025/5960671
  14. base/5871025/5960685
  15. deleting pg_subtrans/0140
  16. base/5871025/5960686
  17. base/5871025/5960687
  18. ...
  19. base/5871025/6154677
  20. base/5871025/6154705
  21. global/pg_control
  22. pg_clog/0014
  23. pg_multixact/members/0000
  24. pg_multixact/offsets/0000
  25. pg_stat_tmp/
  26. pg_stat_tmp/pgstat.stat
  27. pg_subtrans/
  28. pg_subtrans/0141
  29. pg_subtrans/0142
  30.  
  31. sent 3195808 bytes received 5748287 bytes 715527.60 bytes/sec
  32. total size is 1878468069 speedup is 210.02
  33. pg_stop_backup
  34. ----------------
  35. D/C20B8718
  36. (1 row)
  37.  
  38.  
  39. pg_control version number: 903
  40. Catalog version number: 201105231
  41. Database system identifier: 5660417987187833147
  42. Database cluster state: in production
  43. pg_control last modified: Sat 15 Oct 2011 05:55:54 PM MDT
  44. Latest checkpoint location: D/C16DB828
  45. Prior checkpoint location: D/BE54E708
  46. Latest checkpoint's REDO location: D/C10000F8
  47. Latest checkpoint's TimeLineID: 52
  48. Latest checkpoint's NextXID: 0/21116735
  49. Latest checkpoint's NextOID: 6165537
  50. Latest checkpoint's NextMultiXactId: 2944
  51. Latest checkpoint's NextMultiOffset: 5906
  52. Latest checkpoint's oldestXID: 1669
  53. Latest checkpoint's oldestXID's DB: 1
  54. Latest checkpoint's oldestActiveXID: 21116666
  55. Time of latest checkpoint: Sat 15 Oct 2011 05:55:49 PM MDT
  56. Minimum recovery ending location: 0/0
  57. Backup start location: 0/0
  58. Current wal_level setting: hot_standby
  59. Current max_connections setting: 600
  60. Current max_prepared_xacts setting: 0
  61. Current max_locks_per_xact setting: 256
  62. Maximum data alignment: 8
  63. Database block size: 8192
  64. Blocks per segment of large relation: 131072
  65. WAL block size: 8192
  66. Bytes per WAL segment: 16777216
  67. Maximum length of identifiers: 64
  68. Maximum columns in an index: 32
  69. Maximum size of a TOAST chunk: 1996
  70. Date/time type storage: 64-bit integers
  71. Float4 argument passing: by value
  72. Float8 argument passing: by value
  73.  
  74.  
  75. postgres log:
  76. 2011-10-15 17:56:09.161 MDT [11547]: [1-1] LOG: database system was interrupted; last known up at 2011-10-15 17:55:54 MDT
  77. 2011-10-15 17:56:09.161 MDT [11547]: [2-1] LOG: creating missing WAL directory "pg_xlog/archive_status"
  78. 2011-10-15 17:56:09.181 MDT [11547]: [3-1] LOG: entering standby mode
  79. 2011-10-15 17:56:09.185 MDT [11548]: [1-1] LOG: streaming replication successfully connected to primary
  80. 2011-10-15 17:56:09.635 MDT [11566]: [1-1] FATAL: the database system is starting up
  81. 2011-10-15 17:56:09.645 MDT [11568]: [1-1] FATAL: the database system is starting up
  82. 2011-10-15 17:56:09.648 MDT [11572]: [1-1] FATAL: the database system is starting up
  83. 2011-10-15 17:56:09.658 MDT [11584]: [1-1] FATAL: the database system is starting up
  84. 2011-10-15 17:56:09.661 MDT [11586]: [1-1] FATAL: the database system is starting up
  85. 2011-10-15 17:56:09.682 MDT [11547]: [4-1] DEBUG: checkpoint record is at D/C16DB828
  86. 2011-10-15 17:56:09.682 MDT [11547]: [5-1] DEBUG: redo record is at D/C10000F8; shutdown FALSE
  87. 2011-10-15 17:56:09.682 MDT [11547]: [6-1] DEBUG: next transaction ID: 0/21116735; next OID: 6165537
  88. 2011-10-15 17:56:09.682 MDT [11547]: [7-1] DEBUG: next MultiXactId: 2944; next MultiXactOffset: 5906
  89. 2011-10-15 17:56:09.682 MDT [11547]: [8-1] DEBUG: oldest unfrozen transaction ID: 1669, in database 1
  90. 2011-10-15 17:56:09.682 MDT [11547]: [9-1] DEBUG: transaction ID wrap limit is 2147485316, limited by database with OID 1
  91. 2011-10-15 17:56:09.687 MDT [11589]: [1-1] FATAL: the database system is starting up
  92. 2011-10-15 17:56:09.693 MDT [11547]: [10-1] DEBUG: resetting unlogged relations: cleanup 1 init 0
  93. 2011-10-15 17:56:09.701 MDT [11547]: [11-1] DEBUG: initializing for hot standby
  94. 2011-10-15 17:56:09.701 MDT [11547]: [12-1] LOG: consistent recovery state reached at D/C16DB880
  95. 2011-10-15 17:56:09.706 MDT [11547]: [13-1] LOG: redo starts at D/C10000F8
  96. 2011-10-15 17:56:09.735 MDT [11547]: [14-1] FATAL: could not access status of transaction 21110784
  97. 2011-10-15 17:56:09.735 MDT [11547]: [15-1] DETAIL: Could not read from file "pg_subtrans/0142" at offset 32768: Success.
  98. 2011-10-15 17:56:09.735 MDT [11547]: [16-1] CONTEXT: xlog redo xid assignment xtop 21110273: subxacts: 21110274 21110275 21110276 21110277 21110278 21110279 21110280 21110281 21110282 21110283 21110284 21110285 21110286 21110287 21110288 21110289 21110290 21110291 21110292 21110293 21110294 21110295 21110296 21110297 21110298 21110299 21110300 21110301 21110302 21110303 21110304 21110305 21110306 21110307 21110308 21110773 21110774 21110775 21110776 21110777 21110778 21110779 21110780 21110781 21110782 21110783 21110784 21110785 21110786 21110787 21110788 21110789 21110790 21110791 21110792 21110793 21110794 21110795 21110796 21110797 21110798 21110799 21110800 21110801
  99. 2011-10-15 17:56:09.736 MDT [11494]: [2-1] LOG: startup process (PID 11547) exited with exit code 1
  100. 2011-10-15 17:56:09.736 MDT [11494]: [3-1] LOG: terminating any other active server processes
  101. 2011-10-15 17:56:09.799 MDT [11546]: [1-1] DEBUG: logger shutting down
  102.  
  103.  
RAW Paste Data