Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pg_start_backup
- -----------------
- E/F1000020
- (1 row)
- receiving incremental file list
- ./
- backup_label
- postmaster.opts
- base/1/
- base/1/pg_internal.init
- base/12698/
- base/12698/pg_internal.init
- ...
- base/6453041/6514104
- base/6453041/6514110
- deleting global/pgstat.stat
- deleting pg_subtrans/015A
- base/6453041/6514112
- base/6453041/6514114
- ...
- base/6453041/6736709
- base/6453041/pg_internal.init
- global/
- global/pg_control
- global/pg_internal.init
- pg_clog/0015
- pg_multixact/members/0000
- pg_multixact/offsets/0000
- pg_notify/
- pg_notify/0000
- pg_stat_tmp/
- pg_stat_tmp/pgstat.stat
- pg_subtrans/
- pg_subtrans/015B
- sent 3000246 bytes received 7509651 bytes 724820.48 bytes/sec
- total size is 1845881191 speedup is 175.63
- pg_stop_backup
- ----------------
- E/F1F1EFC8
- (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 07:18:50 PM MDT
- Latest checkpoint location: E/F14D98E0
- Prior checkpoint location: E/ED0000E8
- Latest checkpoint's REDO location: E/F1000020
- Latest checkpoint's TimeLineID: 52
- Latest checkpoint's NextXID: 0/22811359
- Latest checkpoint's NextOID: 6751858
- Latest checkpoint's NextMultiXactId: 3128
- Latest checkpoint's NextMultiOffset: 6274
- Latest checkpoint's oldestXID: 1669
- Latest checkpoint's oldestXID's DB: 1
- Latest checkpoint's oldestActiveXID: 22811300
- Time of latest checkpoint: Sat 15 Oct 2011 07:18:45 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 19:19:07.098 MDT [1697]: [1-1] LOG: database system was interrupted; last known up at 2011-10-15 19:18:50 MDT
- 2011-10-15 19:19:07.099 MDT [1697]: [2-1] LOG: creating missing WAL directory "pg_xlog/archive_status"
- 2011-10-15 19:19:07.101 MDT [1697]: [3-1] LOG: entering standby mode
- 2011-10-15 19:19:07.107 MDT [1698]: [1-1] LOG: streaming replication successfully connected to primary
- 2011-10-15 19:19:07.565 MDT [1697]: [4-1] DEBUG: checkpoint record is at E/F14D98E0
- 2011-10-15 19:19:07.565 MDT [1697]: [5-1] DEBUG: redo record is at E/F1000020; shutdown FALSE
- 2011-10-15 19:19:07.565 MDT [1697]: [6-1] DEBUG: next transaction ID: 0/22811359; next OID: 6751858
- 2011-10-15 19:19:07.565 MDT [1697]: [7-1] DEBUG: next MultiXactId: 3128; next MultiXactOffset: 6274
- 2011-10-15 19:19:07.565 MDT [1697]: [8-1] DEBUG: oldest unfrozen transaction ID: 1669, in database 1
- 2011-10-15 19:19:07.565 MDT [1697]: [9-1] DEBUG: transaction ID wrap limit is 2147485316, limited by database with OID 1
- 2011-10-15 19:19:07.571 MDT [1697]: [10-1] DEBUG: resetting unlogged relations: cleanup 1 init 0
- 2011-10-15 19:19:07.579 MDT [1697]: [11-1] DEBUG: initializing for hot standby
- 2011-10-15 19:19:07.579 MDT [1697]: [12-1] FATAL: could not access status of transaction 22811359
- 2011-10-15 19:19:07.579 MDT [1697]: [13-1] DETAIL: Could not read from file "pg_clog/0015" at offset 196608: Success.
- 2011-10-15 19:19:07.579 MDT [1644]: [2-1] LOG: startup process (PID 1697) exited with exit code 1
- 2011-10-15 19:19:07.579 MDT [1644]: [3-1] LOG: aborting startup due to startup process failure
- 2011-10-15 19:19:07.660 MDT [1696]: [1-1] DEBUG: logger shutting down
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement