PostgreSQL Source Code  git master
pg_control.h
Go to the documentation of this file.
1 /*-------------------------------------------------------------------------
2  *
3  * pg_control.h
4  * The system control file "pg_control" is not a heap relation.
5  * However, we define it here so that the format is documented.
6  *
7  *
8  * Portions Copyright (c) 1996-2023, PostgreSQL Global Development Group
9  * Portions Copyright (c) 1994, Regents of the University of California
10  *
11  * src/include/catalog/pg_control.h
12  *
13  *-------------------------------------------------------------------------
14  */
15 #ifndef PG_CONTROL_H
16 #define PG_CONTROL_H
17 
18 #include "access/transam.h"
19 #include "access/xlogdefs.h"
20 #include "pgtime.h" /* for pg_time_t */
21 #include "port/pg_crc32c.h"
22 
23 
24 /* Version identifier for this pg_control format */
25 #define PG_CONTROL_VERSION 1300
26 
27 /* Nonce key length, see below */
28 #define MOCK_AUTH_NONCE_LEN 32
29 
30 /*
31  * Body of CheckPoint XLOG records. This is declared here because we keep
32  * a copy of the latest one in pg_control for possible disaster recovery.
33  * Changing this struct requires a PG_CONTROL_VERSION bump.
34  */
35 typedef struct CheckPoint
36 {
37  XLogRecPtr redo; /* next RecPtr available when we began to
38  * create CheckPoint (i.e. REDO start point) */
39  TimeLineID ThisTimeLineID; /* current TLI */
40  TimeLineID PrevTimeLineID; /* previous TLI, if this record begins a new
41  * timeline (equals ThisTimeLineID otherwise) */
42  bool fullPageWrites; /* current full_page_writes */
43  FullTransactionId nextXid; /* next free transaction ID */
44  Oid nextOid; /* next free OID */
45  MultiXactId nextMulti; /* next free MultiXactId */
46  MultiXactOffset nextMultiOffset; /* next free MultiXact offset */
47  TransactionId oldestXid; /* cluster-wide minimum datfrozenxid */
48  Oid oldestXidDB; /* database with minimum datfrozenxid */
49  MultiXactId oldestMulti; /* cluster-wide minimum datminmxid */
50  Oid oldestMultiDB; /* database with minimum datminmxid */
51  pg_time_t time; /* time stamp of checkpoint */
52  TransactionId oldestCommitTsXid; /* oldest Xid with valid commit
53  * timestamp */
54  TransactionId newestCommitTsXid; /* newest Xid with valid commit
55  * timestamp */
56 
57  /*
58  * Oldest XID still running. This is only needed to initialize hot standby
59  * mode from an online checkpoint, so we only bother calculating this for
60  * online checkpoints and only when wal_level is replica. Otherwise it's
61  * set to InvalidTransactionId.
62  */
65 
66 /* XLOG info values for XLOG rmgr */
67 #define XLOG_CHECKPOINT_SHUTDOWN 0x00
68 #define XLOG_CHECKPOINT_ONLINE 0x10
69 #define XLOG_NOOP 0x20
70 #define XLOG_NEXTOID 0x30
71 #define XLOG_SWITCH 0x40
72 #define XLOG_BACKUP_END 0x50
73 #define XLOG_PARAMETER_CHANGE 0x60
74 #define XLOG_RESTORE_POINT 0x70
75 #define XLOG_FPW_CHANGE 0x80
76 #define XLOG_END_OF_RECOVERY 0x90
77 #define XLOG_FPI_FOR_HINT 0xA0
78 #define XLOG_FPI 0xB0
79 /* 0xC0 is used in Postgres 9.5-11 */
80 #define XLOG_OVERWRITE_CONTRECORD 0xD0
81 
82 
83 /*
84  * System status indicator. Note this is stored in pg_control; if you change
85  * it, you must bump PG_CONTROL_VERSION
86  */
87 typedef enum DBState
88 {
97 
98 /*
99  * Contents of pg_control.
100  */
101 
102 typedef struct ControlFileData
103 {
104  /*
105  * Unique system identifier --- to ensure we match up xlog files with the
106  * installation that produced them.
107  */
109 
110  /*
111  * Version identifier information. Keep these fields at the same offset,
112  * especially pg_control_version; they won't be real useful if they move
113  * around. (For historical reasons they must be 8 bytes into the file
114  * rather than immediately at the front.)
115  *
116  * pg_control_version identifies the format of pg_control itself.
117  * catalog_version_no identifies the format of the system catalogs.
118  *
119  * There are additional version identifiers in individual files; for
120  * example, WAL logs contain per-page magic numbers that can serve as
121  * version cues for the WAL log.
122  */
123  uint32 pg_control_version; /* PG_CONTROL_VERSION */
124  uint32 catalog_version_no; /* see catversion.h */
125 
126  /*
127  * System status data
128  */
129  DBState state; /* see enum above */
130  pg_time_t time; /* time stamp of last pg_control update */
131  XLogRecPtr checkPoint; /* last check point record ptr */
132 
133  CheckPoint checkPointCopy; /* copy of last check point record */
134 
135  XLogRecPtr unloggedLSN; /* current fake LSN value, for unlogged rels */
136 
137  /*
138  * These two values determine the minimum point we must recover up to
139  * before starting up:
140  *
141  * minRecoveryPoint is updated to the latest replayed LSN whenever we
142  * flush a data change during archive recovery. That guards against
143  * starting archive recovery, aborting it, and restarting with an earlier
144  * stop location. If we've already flushed data changes from WAL record X
145  * to disk, we mustn't start up until we reach X again. Zero when not
146  * doing archive recovery.
147  *
148  * backupStartPoint is the redo pointer of the backup start checkpoint, if
149  * we are recovering from an online backup and haven't reached the end of
150  * backup yet. It is reset to zero when the end of backup is reached, and
151  * we mustn't start up before that. A boolean would suffice otherwise, but
152  * we use the redo pointer as a cross-check when we see an end-of-backup
153  * record, to make sure the end-of-backup record corresponds the base
154  * backup we're recovering from.
155  *
156  * backupEndPoint is the backup end location, if we are recovering from an
157  * online backup which was taken from the standby and haven't reached the
158  * end of backup yet. It is initialized to the minimum recovery point in
159  * pg_control which was backed up last. It is reset to zero when the end
160  * of backup is reached, and we mustn't start up before that.
161  *
162  * If backupEndRequired is true, we know for sure that we're restoring
163  * from a backup, and must see a backup-end record before we can safely
164  * start up.
165  */
171 
172  /*
173  * Parameter settings that determine if the WAL can be used for archival
174  * or hot standby.
175  */
184 
185  /*
186  * This data is used to check for hardware-architecture compatibility of
187  * the database and the backend executable. We need not check endianness
188  * explicitly, since the pg_control version will surely look wrong to a
189  * machine of different endianness, but we do need to worry about MAXALIGN
190  * and floating-point format. (Note: storage layout nominally also
191  * depends on SHORTALIGN and INTALIGN, but in practice these are the same
192  * on all architectures of interest.)
193  *
194  * Testing just one double value is not a very bulletproof test for
195  * floating-point compatibility, but it will catch most cases.
196  */
197  uint32 maxAlign; /* alignment requirement for tuples */
198  double floatFormat; /* constant 1234567.0 */
199 #define FLOATFORMAT_VALUE 1234567.0
200 
201  /*
202  * This data is used to make sure that configuration of this database is
203  * compatible with the backend executable.
204  */
205  uint32 blcksz; /* data block size for this DB */
206  uint32 relseg_size; /* blocks per segment of large relation */
207 
208  uint32 xlog_blcksz; /* block size within WAL files */
209  uint32 xlog_seg_size; /* size of each WAL segment */
210 
211  uint32 nameDataLen; /* catalog name field width */
212  uint32 indexMaxKeys; /* max number of columns in an index */
213 
214  uint32 toast_max_chunk_size; /* chunk size in TOAST tables */
215  uint32 loblksize; /* chunk size in pg_largeobject */
216 
217  bool float8ByVal; /* float8, int8, etc pass-by-value? */
218 
219  /* Are data pages protected by checksums? Zero if no checksum version */
221 
222  /*
223  * Random nonce, used in authentication requests that need to proceed
224  * based on values that are cluster-unique, like a SASL exchange that
225  * failed at an early stage.
226  */
228 
229  /* CRC of all above ... MUST BE LAST! */
232 
233 /*
234  * Maximum safe value of sizeof(ControlFileData). For reliability's sake,
235  * it's critical that pg_control updates be atomic writes. That generally
236  * means the active data can't be more than one disk sector, which is 512
237  * bytes on common hardware. Be very careful about raising this limit.
238  */
239 #define PG_CONTROL_MAX_SAFE_SIZE 512
240 
241 /*
242  * Physical size of the pg_control file. Note that this is considerably
243  * bigger than the actually used size (ie, sizeof(ControlFileData)).
244  * The idea is to keep the physical size constant independent of format
245  * changes, so that ReadControlFile will deliver a suitable wrong-version
246  * message instead of a read error if it's looking at an incompatible file.
247  */
248 #define PG_CONTROL_FILE_SIZE 8192
249 
250 /*
251  * Ensure that the size of the pg_control data structure is sane.
252  */
254  "pg_control is too large for atomic disk writes");
256  "sizeof(ControlFileData) exceeds PG_CONTROL_FILE_SIZE");
257 
258 #endif /* PG_CONTROL_H */
unsigned int uint32
Definition: c.h:495
uint32 MultiXactOffset
Definition: c.h:653
TransactionId MultiXactId
Definition: c.h:651
uint32 TransactionId
Definition: c.h:641
struct ControlFileData ControlFileData
StaticAssertDecl(sizeof(ControlFileData)<=PG_CONTROL_MAX_SAFE_SIZE, "pg_control is too large for atomic disk writes")
#define PG_CONTROL_MAX_SAFE_SIZE
Definition: pg_control.h:239
struct CheckPoint CheckPoint
#define MOCK_AUTH_NONCE_LEN
Definition: pg_control.h:28
DBState
Definition: pg_control.h:88
@ DB_IN_PRODUCTION
Definition: pg_control.h:95
@ DB_STARTUP
Definition: pg_control.h:89
@ DB_SHUTDOWNING
Definition: pg_control.h:92
@ DB_IN_ARCHIVE_RECOVERY
Definition: pg_control.h:94
@ DB_SHUTDOWNED_IN_RECOVERY
Definition: pg_control.h:91
@ DB_SHUTDOWNED
Definition: pg_control.h:90
@ DB_IN_CRASH_RECOVERY
Definition: pg_control.h:93
#define PG_CONTROL_FILE_SIZE
Definition: pg_control.h:248
uint32 pg_crc32c
Definition: pg_crc32c.h:38
int64 pg_time_t
Definition: pgtime.h:23
unsigned int Oid
Definition: postgres_ext.h:31
Oid oldestMultiDB
Definition: pg_control.h:50
MultiXactId oldestMulti
Definition: pg_control.h:49
MultiXactOffset nextMultiOffset
Definition: pg_control.h:46
TransactionId newestCommitTsXid
Definition: pg_control.h:54
TransactionId oldestXid
Definition: pg_control.h:47
TimeLineID PrevTimeLineID
Definition: pg_control.h:40
TimeLineID ThisTimeLineID
Definition: pg_control.h:39
Oid nextOid
Definition: pg_control.h:44
TransactionId oldestActiveXid
Definition: pg_control.h:63
bool fullPageWrites
Definition: pg_control.h:42
MultiXactId nextMulti
Definition: pg_control.h:45
FullTransactionId nextXid
Definition: pg_control.h:43
TransactionId oldestCommitTsXid
Definition: pg_control.h:52
pg_time_t time
Definition: pg_control.h:51
XLogRecPtr redo
Definition: pg_control.h:37
Oid oldestXidDB
Definition: pg_control.h:48
char mock_authentication_nonce[MOCK_AUTH_NONCE_LEN]
Definition: pg_control.h:227
int max_worker_processes
Definition: pg_control.h:179
uint32 pg_control_version
Definition: pg_control.h:123
uint32 xlog_seg_size
Definition: pg_control.h:209
XLogRecPtr backupStartPoint
Definition: pg_control.h:168
bool track_commit_timestamp
Definition: pg_control.h:183
bool backupEndRequired
Definition: pg_control.h:170
int max_locks_per_xact
Definition: pg_control.h:182
uint32 nameDataLen
Definition: pg_control.h:211
CheckPoint checkPointCopy
Definition: pg_control.h:133
XLogRecPtr backupEndPoint
Definition: pg_control.h:169
XLogRecPtr minRecoveryPoint
Definition: pg_control.h:166
uint32 data_checksum_version
Definition: pg_control.h:220
XLogRecPtr unloggedLSN
Definition: pg_control.h:135
uint32 indexMaxKeys
Definition: pg_control.h:212
uint32 relseg_size
Definition: pg_control.h:206
pg_time_t time
Definition: pg_control.h:130
XLogRecPtr checkPoint
Definition: pg_control.h:131
uint64 system_identifier
Definition: pg_control.h:108
uint32 catalog_version_no
Definition: pg_control.h:124
double floatFormat
Definition: pg_control.h:198
int max_prepared_xacts
Definition: pg_control.h:181
uint32 xlog_blcksz
Definition: pg_control.h:208
TimeLineID minRecoveryPointTLI
Definition: pg_control.h:167
uint32 loblksize
Definition: pg_control.h:215
pg_crc32c crc
Definition: pg_control.h:230
uint32 toast_max_chunk_size
Definition: pg_control.h:214
uint64 XLogRecPtr
Definition: xlogdefs.h:21
uint32 TimeLineID
Definition: xlogdefs.h:59