1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
$ fq -d pg_control -o flavour=postgres15 dv pg_control
|00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d 0e 0f|0123456789abcdef|.{}: pg_control (pg_control) 0x0-0x2000 (8192)
0x0000|6c a6 bc 14 92 e4 33 64 |l.....3d | system_identifier: 7220365943669302892 0x0-0x8 (8)
0x0000| 14 05 00 00 | .... | pg_control_version: 1300 0x8-0xc (4)
0x0000| 25 77 0d 0c| %w..| catalog_version_no: 202209061 0xc-0x10 (4)
0x0010|06 00 00 00 |.... | state: "DB_IN_PRODUCTION" (6) 0x10-0x14 (4)
0x0010| 00 00 00 00 | .... | hole0: 0 0x14-0x18 (4)
0x0010| 27 ec 33 64 00 00 00 00| '.3d....| time: "Mon, 10 Apr 2023 10:59:51 UTC" (1681124391) 0x18-0x20 (8)
0x0020|f8 f9 42 02 00 00 00 00 |..B..... | check_point: "0/242F9F8" (37943800) 0x20-0x28 (8)
| | | check_point_copy{}: 0x28-0x80 (88)
0x0020| c0 f9 42 02 00 00 00 00| ..B.....| redo: "0/242F9C0" (37943744) 0x28-0x30 (8)
0x0030|01 00 00 00 |.... | this_time_line_id: 1 0x30-0x34 (4)
0x0030| 01 00 00 00 | .... | prev_time_line_id: 1 0x34-0x38 (4)
0x0030| 01 | . | full_page_writes: 1 0x38-0x39 (1)
0x0030| 00 00 00 00 00 00 00| .......| hole1: 0 0x39-0x40 (7)
0x0040|ea 02 00 00 00 00 00 00 |........ | next_xid: 746 0x40-0x48 (8)
0x0040| 00 60 00 00 | .`.. | next_oid: 24576 0x48-0x4c (4)
0x0040| 01 00 00 00| ....| next_multi: 1 0x4c-0x50 (4)
0x0050|00 00 00 00 |.... | next_multi_offset: 0 0x50-0x54 (4)
0x0050| cc 02 00 00 | .... | oldest_xid: 716 0x54-0x58 (4)
0x0050| 01 00 00 00 | .... | oldest_xid_db: 1 0x58-0x5c (4)
0x0050| 01 00 00 00| ....| oldest_multi: 1 0x5c-0x60 (4)
0x0060|01 00 00 00 |.... | oldest_multi_db: 1 0x60-0x64 (4)
0x0060| 00 00 00 00 | .... | hole2: 0 0x64-0x68 (4)
0x0060| 27 ec 33 64 00 00 00 00| '.3d....| time: "Mon, 10 Apr 2023 10:59:51 UTC" (1681124391) 0x68-0x70 (8)
0x0070|00 00 00 00 |.... | oldest_commit_ts_xid: 0 0x70-0x74 (4)
0x0070| 00 00 00 00 | .... | newest_commit_ts_xid: 0 0x74-0x78 (4)
0x0070| ea 02 00 00 | .... | oldest_active_xid: 746 0x78-0x7c (4)
0x0070| 00 00 00 00| ....| padding0: 0 0x7c-0x80 (4)
0x0080|e8 03 00 00 00 00 00 00 |........ | unlogged_lsn: "0/3E8" (1000) 0x80-0x88 (8)
0x0080| 00 00 00 00 00 00 00 00| ........| min_recovery_point: "0/0" (0) 0x88-0x90 (8)
0x0090|00 00 00 00 |.... | min_recovery_point_tli: 0 0x90-0x94 (4)
0x0090| 00 00 00 00 | .... | hole3: 0 0x94-0x98 (4)
0x0090| 00 00 00 00 00 00 00 00| ........| backup_start_point: "0/0" (0) 0x98-0xa0 (8)
0x00a0|00 00 00 00 00 00 00 00 |........ | backup_end_point: "0/0" (0) 0xa0-0xa8 (8)
0x00a0| 00 | . | backup_end_required: 0 0xa8-0xa9 (1)
0x00a0| 00 00 00 | ... | hole4: 0 0xa9-0xac (3)
0x00a0| 01 00 00 00| ....| wal_level: "WAL_LEVEL_REPLICA" (1) 0xac-0xb0 (4)
0x00b0|00 |. | wal_log_hints: 0 0xb0-0xb1 (1)
0x00b0| 00 00 00 | ... | hole5: 0 0xb1-0xb4 (3)
0x00b0| e8 03 00 00 | .... | max_connections: 1000 0xb4-0xb8 (4)
0x00b0| 08 00 00 00 | .... | max_worker_processes: 8 0xb8-0xbc (4)
0x00b0| 0a 00 00 00| ....| max_wal_senders: 10 0xbc-0xc0 (4)
0x00c0|00 00 00 00 |.... | max_prepared_xacts: 0 0xc0-0xc4 (4)
0x00c0| 40 00 00 00 | @... | max_locks_per_xact: 64 0xc4-0xc8 (4)
0x00c0| 00 | . | track_commit_timestamp: 0 0xc8-0xc9 (1)
0x00c0| 00 00 00 | ... | hole6: 0 0xc9-0xcc (3)
0x00c0| 08 00 00 00| ....| max_align: 8 0xcc-0xd0 (4)
0x00d0|00 00 00 00 87 d6 32 41 |......2A | float_format: 1.234567e+06 0xd0-0xd8 (8)
0x00d0| 00 20 00 00 | . .. | blcksz: 8192 0xd8-0xdc (4)
0x00d0| 00 00 02 00| ....| relseg_size: 131072 0xdc-0xe0 (4)
0x00e0|00 20 00 00 |. .. | xlog_blcksz: 8192 0xe0-0xe4 (4)
0x00e0| 00 00 00 01 | .... | xlog_seg_size: 16777216 0xe4-0xe8 (4)
0x00e0| 40 00 00 00 | @... | name_data_len: 64 0xe8-0xec (4)
0x00e0| 20 00 00 00| ...| index_max_keys: 32 0xec-0xf0 (4)
0x00f0|cc 07 00 00 |.... | toast_max_chunk_size: 1996 0xf0-0xf4 (4)
0x00f0| 00 08 00 00 | .... | loblksize: 2048 0xf4-0xf8 (4)
0x00f0| 01 | . | float8_by_val: 1 0xf8-0xf9 (1)
0x00f0| 00 00 00 | ... | hole7: 0 0xf9-0xfc (3)
0x00f0| 01 00 00 00| ....| data_checksum_version: 1 0xfc-0x100 (4)
0x0100|77 a5 b6 b0 15 ae 34 8a e2 a1 87 a2 0e 81 df 5c|w.....4........\| mock_authentication_nonce: "77a5b6b015ae348ae2a187a20e81df5c2d061053e3bc79e..." (raw bits) 0x100-0x120 (32)
0x0110|2d 06 10 53 e3 bc 79 e3 04 a7 64 df 23 57 d6 b0|-..S..y...d.#W..|
0x0120|d9 db d0 cd |.... | crc: 3453017049 0x120-0x124 (4)
0x0120| 00 00 00 00 | .... | padding1: 0 0x124-0x128 (4)
0x0120| 00 00 00 00 00 00 00 00| ........| unused: raw bits 0x128-0x2000 (7896)
0x0130|00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00|................|
* |until 0x1fff.7 (end) (7896) | |
|
