pg_controldata - Mailing list pgsql-hackers

From Thomas Lockhart
Subject pg_controldata
Date
Msg-id 3D25BC87.A85A745C@fourpalms.org
Whole thread Raw
List 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 by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Issues Outstanding for Point In Time Recovery (PITR)
Next
From: Lamar Owen
Date:
Subject: Re: (A) native Windows port