On Mon, Sep 15, 2008 at 1:09 PM, Eliot, Christopher <christopher.eliot@xxxxxxxxxxxxx> wrote: > My server machine (actually my windows workstation) became very ill, so the > IT folks gave me a new workstation, but installed the disk drive from the > old workstation in the new one as a secondary drive. P.s. the pg_controldata program is quite useful here, if you have it installed. sudo -u postgres ./pg_controldata /var/lib/postgresql/8.3/main/ shows me this on my machine: pg_control version number: 833 Catalog version number: 200711281 Database system identifier: 5177107589293985791 Database cluster state: in production pg_control last modified: Mon 15 Sep 2008 08:49:24 AM MDT Latest checkpoint location: 0/498490 Prior checkpoint location: 0/498450 Latest checkpoint's REDO location: 0/498490 Latest checkpoint's TimeLineID: 1 Latest checkpoint's NextXID: 0/401 Latest checkpoint's NextOID: 24603 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Time of latest checkpoint: Mon 15 Sep 2008 08:47:07 AM MDT 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 Maximum length of locale name: 128 LC_COLLATE: en_US LC_CTYPE: en_US Most all that stuff needs to match up between the two directories.
