Guest User

Untitled

a guest
Oct 15th, 2011
146
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. pg_start_backup
  2. -----------------
  3. E/F1000020
  4. (1 row)
  5.  
  6. receiving incremental file list
  7. ./
  8. backup_label
  9. postmaster.opts
  10. base/1/
  11. base/1/pg_internal.init
  12. base/12698/
  13. base/12698/pg_internal.init
  14. ...
  15. base/6453041/6514104
  16. base/6453041/6514110
  17. deleting global/pgstat.stat
  18. deleting pg_subtrans/015A
  19. base/6453041/6514112
  20. base/6453041/6514114
  21. ...
  22. base/6453041/6736709
  23. base/6453041/pg_internal.init
  24. global/
  25. global/pg_control
  26. global/pg_internal.init
  27. pg_clog/0015
  28. pg_multixact/members/0000
  29. pg_multixact/offsets/0000
  30. pg_notify/
  31. pg_notify/0000
  32. pg_stat_tmp/
  33. pg_stat_tmp/pgstat.stat
  34. pg_subtrans/
  35. pg_subtrans/015B
  36.  
  37. sent 3000246 bytes received 7509651 bytes 724820.48 bytes/sec
  38. total size is 1845881191 speedup is 175.63
  39. pg_stop_backup
  40. ----------------
  41. E/F1F1EFC8
  42. (1 row)
  43.  
  44.  
  45. pg_control version number: 903
  46. Catalog version number: 201105231
  47. Database system identifier: 5660417987187833147
  48. Database cluster state: in production
  49. pg_control last modified: Sat 15 Oct 2011 07:18:50 PM MDT
  50. Latest checkpoint location: E/F14D98E0
  51. Prior checkpoint location: E/ED0000E8
  52. Latest checkpoint's REDO location: E/F1000020
  53. Latest checkpoint's TimeLineID: 52
  54. Latest checkpoint's NextXID: 0/22811359
  55. Latest checkpoint's NextOID: 6751858
  56. Latest checkpoint's NextMultiXactId: 3128
  57. Latest checkpoint's NextMultiOffset: 6274
  58. Latest checkpoint's oldestXID: 1669
  59. Latest checkpoint's oldestXID's DB: 1
  60. Latest checkpoint's oldestActiveXID: 22811300
  61. Time of latest checkpoint: Sat 15 Oct 2011 07:18:45 PM MDT
  62. Minimum recovery ending location: 0/0
  63. Backup start location: 0/0
  64. Current wal_level setting: hot_standby
  65. Current max_connections setting: 600
  66. Current max_prepared_xacts setting: 0
  67. Current max_locks_per_xact setting: 256
  68. Maximum data alignment: 8
  69. Database block size: 8192
  70. Blocks per segment of large relation: 131072
  71. WAL block size: 8192
  72. Bytes per WAL segment: 16777216
  73. Maximum length of identifiers: 64
  74. Maximum columns in an index: 32
  75. Maximum size of a TOAST chunk: 1996
  76. Date/time type storage: 64-bit integers
  77. Float4 argument passing: by value
  78. Float8 argument passing: by value
  79.  
  80. postgres log:
  81. 2011-10-15 19:19:07.098 MDT [1697]: [1-1] LOG: database system was interrupted; last known up at 2011-10-15 19:18:50 MDT
  82. 2011-10-15 19:19:07.099 MDT [1697]: [2-1] LOG: creating missing WAL directory "pg_xlog/archive_status"
  83. 2011-10-15 19:19:07.101 MDT [1697]: [3-1] LOG: entering standby mode
  84. 2011-10-15 19:19:07.107 MDT [1698]: [1-1] LOG: streaming replication successfully connected to primary
  85. 2011-10-15 19:19:07.565 MDT [1697]: [4-1] DEBUG: checkpoint record is at E/F14D98E0
  86. 2011-10-15 19:19:07.565 MDT [1697]: [5-1] DEBUG: redo record is at E/F1000020; shutdown FALSE
  87. 2011-10-15 19:19:07.565 MDT [1697]: [6-1] DEBUG: next transaction ID: 0/22811359; next OID: 6751858
  88. 2011-10-15 19:19:07.565 MDT [1697]: [7-1] DEBUG: next MultiXactId: 3128; next MultiXactOffset: 6274
  89. 2011-10-15 19:19:07.565 MDT [1697]: [8-1] DEBUG: oldest unfrozen transaction ID: 1669, in database 1
  90. 2011-10-15 19:19:07.565 MDT [1697]: [9-1] DEBUG: transaction ID wrap limit is 2147485316, limited by database with OID 1
  91. 2011-10-15 19:19:07.571 MDT [1697]: [10-1] DEBUG: resetting unlogged relations: cleanup 1 init 0
  92. 2011-10-15 19:19:07.579 MDT [1697]: [11-1] DEBUG: initializing for hot standby
  93. 2011-10-15 19:19:07.579 MDT [1697]: [12-1] FATAL: could not access status of transaction 22811359
  94. 2011-10-15 19:19:07.579 MDT [1697]: [13-1] DETAIL: Could not read from file "pg_clog/0015" at offset 196608: Success.
  95. 2011-10-15 19:19:07.579 MDT [1644]: [2-1] LOG: startup process (PID 1697) exited with exit code 1
  96. 2011-10-15 19:19:07.579 MDT [1644]: [3-1] LOG: aborting startup due to startup process failure
  97. 2011-10-15 19:19:07.660 MDT [1696]: [1-1] DEBUG: logger shutting down
  98.  
  99.  
RAW Paste Data