pg_controldata
| От | Thomas Lockhart |
|---|---|
| Тема | pg_controldata |
| Дата | |
| Msg-id | 3D25BC87.A85A745C@fourpalms.org обсуждение исходный текст |
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: