Greg Stark wrote:
On Sun, Aug 23, 2009 at 5:02 PM, Greg Stark<gsstark@xxxxxxx> wrote:
On Sun, Aug 23, 2009 at 2:18 PM, Jeff Ross<jross@xxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
