From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "Eliot, Christopher" <christopher(dot)eliot(at)nagrastar(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Moving DB data disk to a different machine |
Date: | 2008-09-15 20:05:12 |
Message-ID: | dcc563d10809151305h22a9775avb003031fd3e52095@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Trent Pingenot | 2008-09-15 21:07:22 | Permissions Scenerio |
Previous Message | Scott Marlowe | 2008-09-15 20:01:41 | Re: Moving DB data disk to a different machine |