Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pg_start_backup
- -----------------
- D/C10000F8
- (1 row)
- receiving incremental file list
- ./
- backup_label
- base/16411/12435
- base/16411/5876734
- base/5871025/
- ...
- base/5871025/5960671
- base/5871025/5960685
- deleting pg_subtrans/0140
- base/5871025/5960686
- base/5871025/5960687
- ...
- base/5871025/6154677
- base/5871025/6154705
- global/pg_control
- pg_clog/0014
- pg_multixact/members/0000
- pg_multixact/offsets/0000
- pg_stat_tmp/
- pg_stat_tmp/pgstat.stat
- pg_subtrans/
- pg_subtrans/0141
- pg_subtrans/0142
- sent 3195808 bytes received 5748287 bytes 715527.60 bytes/sec
- total size is 1878468069 speedup is 210.02
- pg_stop_backup
- ----------------
- D/C20B8718
- (1 row)
- pg_control version number: 903
- Catalog version number: 201105231
- Database system identifier: 5660417987187833147
- Database cluster state: in production
- pg_control last modified: Sat 15 Oct 2011 05:55:54 PM MDT
- Latest checkpoint location: D/C16DB828
- Prior checkpoint location: D/BE54E708
- Latest checkpoint's REDO location: D/C10000F8
- Latest checkpoint's TimeLineID: 52
- Latest checkpoint's NextXID: 0/21116735
- Latest checkpoint's NextOID: 6165537
- Latest checkpoint's NextMultiXactId: 2944
- Latest checkpoint's NextMultiOffset: 5906
- Latest checkpoint's oldestXID: 1669
- Latest checkpoint's oldestXID's DB: 1
- Latest checkpoint's oldestActiveXID: 21116666
- Time of latest checkpoint: Sat 15 Oct 2011 05:55:49 PM MDT
- Minimum recovery ending location: 0/0
- Backup start location: 0/0
- Current wal_level setting: hot_standby
- Current max_connections setting: 600
- Current max_prepared_xacts setting: 0
- Current max_locks_per_xact setting: 256
- Maximum data alignment: 8
- Database block size: 8192
- Blocks per segment of large relation: 131072
- WAL block size: 8192
- Bytes per WAL segment: 16777216
- Maximum length of identifiers: 64
- Maximum columns in an index: 32
- Maximum size of a TOAST chunk: 1996
- Date/time type storage: 64-bit integers
- Float4 argument passing: by value
- Float8 argument passing: by value
- postgres log:
- 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
- 2011-10-15 17:56:09.161 MDT [11547]: [2-1] LOG: creating missing WAL directory "pg_xlog/archive_status"
- 2011-10-15 17:56:09.181 MDT [11547]: [3-1] LOG: entering standby mode
- 2011-10-15 17:56:09.185 MDT [11548]: [1-1] LOG: streaming replication successfully connected to primary
- 2011-10-15 17:56:09.635 MDT [11566]: [1-1] FATAL: the database system is starting up
- 2011-10-15 17:56:09.645 MDT [11568]: [1-1] FATAL: the database system is starting up
- 2011-10-15 17:56:09.648 MDT [11572]: [1-1] FATAL: the database system is starting up
- 2011-10-15 17:56:09.658 MDT [11584]: [1-1] FATAL: the database system is starting up
- 2011-10-15 17:56:09.661 MDT [11586]: [1-1] FATAL: the database system is starting up
- 2011-10-15 17:56:09.682 MDT [11547]: [4-1] DEBUG: checkpoint record is at D/C16DB828
- 2011-10-15 17:56:09.682 MDT [11547]: [5-1] DEBUG: redo record is at D/C10000F8; shutdown FALSE
- 2011-10-15 17:56:09.682 MDT [11547]: [6-1] DEBUG: next transaction ID: 0/21116735; next OID: 6165537
- 2011-10-15 17:56:09.682 MDT [11547]: [7-1] DEBUG: next MultiXactId: 2944; next MultiXactOffset: 5906
- 2011-10-15 17:56:09.682 MDT [11547]: [8-1] DEBUG: oldest unfrozen transaction ID: 1669, in database 1
- 2011-10-15 17:56:09.682 MDT [11547]: [9-1] DEBUG: transaction ID wrap limit is 2147485316, limited by database with OID 1
- 2011-10-15 17:56:09.687 MDT [11589]: [1-1] FATAL: the database system is starting up
- 2011-10-15 17:56:09.693 MDT [11547]: [10-1] DEBUG: resetting unlogged relations: cleanup 1 init 0
- 2011-10-15 17:56:09.701 MDT [11547]: [11-1] DEBUG: initializing for hot standby
- 2011-10-15 17:56:09.701 MDT [11547]: [12-1] LOG: consistent recovery state reached at D/C16DB880
- 2011-10-15 17:56:09.706 MDT [11547]: [13-1] LOG: redo starts at D/C10000F8
- 2011-10-15 17:56:09.735 MDT [11547]: [14-1] FATAL: could not access status of transaction 21110784
- 2011-10-15 17:56:09.735 MDT [11547]: [15-1] DETAIL: Could not read from file "pg_subtrans/0142" at offset 32768: Success.
- 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
- 2011-10-15 17:56:09.736 MDT [11494]: [2-1] LOG: startup process (PID 11547) exited with exit code 1
- 2011-10-15 17:56:09.736 MDT [11494]: [3-1] LOG: terminating any other active server processes
- 2011-10-15 17:56:09.799 MDT [11546]: [1-1] DEBUG: logger shutting down
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement