Re: Multiple table entries?

Greg Stark wrote:
> On Sun, Aug 23, 2009 at 5:02 PM, Greg Stark<gsstark@mit.edu> wrote:
>
>> On Sun, Aug 23, 2009 at 2:18 PM, Jeff Ross<jross@wykids.org> wrote:
>> Incidentally, may as well ask the usual questions:
>>
>
> And just for reference, what does pg_controldata print?
>
>
_postgresql@heinlein:/var/postgresql $
pg_controldata
pg_control version number:            843
Catalog version number:               200904091
Database system identifier:           5368117850282091454
Database cluster state:               in production
pg_control last modified:             Sun Aug 23 10:37:39 2009
Latest checkpoint location:           0/4203B43C
Prior checkpoint location:            0/4202F978
Latest checkpoint's REDO location:    0/4203B43C
Latest checkpoint's TimeLineID:       1
Latest checkpoint's NextXID:          0/116884
Latest checkpoint's NextOID:          866525
Latest checkpoint's NextMultiXactId:  1
Latest checkpoint's NextMultiOffset:  0
Time of latest checkpoint:            Sun Aug 23 10:37:38 2009
Minimum recovery ending location:     0/0
Maximum data alignment:               4
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        2000
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by reference