Re: Moving DB data disk to a different machine

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux