Re: Moving DB data disk to a different machine

On Mon, Sep 15, 2008 at 1:09 PM, Eliot, Christopher
<christopher(dot)eliot(at)nagrastar(dot)com> 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.