I modified pg_controldata to display a few new fields. Example output
appears at the end of this message, and the cvs log is:
Add a few new lines to display recently added fields in the ControlFile structure.
Now includes the following new fields:integer/float date/time storagemaximum length of names (+1; they must also
includea null termination)maximum number of function argumentsmaximum length of locale name
- Thomas
myst$ ./pg_controldata
pg_control version number: 72
Catalog version number: 200207021
Database state: IN_PRODUCTION
pg_control last modified: Fri Jul 5 08:33:18 2002
Current log file id: 0
Next log file segment: 2
Latest checkpoint location: 0/1663838
Prior checkpoint location: 0/16637F8
Latest checkpoint's REDO location: 0/1663838
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 12
Latest checkpoint's NextXID: 4925
Latest checkpoint's NextOID: 139958
Time of latest checkpoint: Fri Jul 5 08:33:01 2002
Database block size: 8192
Blocks per segment of large relation: 131072
Maximum length of names: 32
Maximum number of function arguments: 16
Date/time type storage: 64-bit integers
Maximum length of locale name: 128
LC_COLLATE: C
LC_CTYPE: C