| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg_controldata |
| Date: | 2002-07-05 15:34:31 |
| Message-ID: | 3D25BC87.A85A745C@fourpalms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 storage
maximum length of names (+1; they must also include a null termination)
maximum number of function arguments
maximum 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB SD | 2002-07-05 15:39:09 | Re: Issues Outstanding for Point In Time Recovery (PITR) |
| Previous Message | Tatsuo Ishii | 2002-07-05 15:33:30 | Re: Proposal: CREATE CONVERSION |