DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=gY0rwxzQIIao8PcDe9PM8I0akCc/r66C3RTtQRig5RwJJfLNlvw7ZkWR2d3XoqgO4D
	fEBMR4nM9UMgaBzE1CEbmqLAqBEhGk/JauFbUBFnmhwAN3qflg5dL+3NHJbxizHCF+L+
	Q732VbgiB0LGl3yIRHgpV/QhpMj2f48zuWTFY=
Message-ID: <dcc563d10809151301i23d7c255ne7c950ff41db70ee@mail.gmail.com>
Date: Mon, 15 Sep 2008 14:01:41 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Eliot, Christopher" <christopher.eliot@nagrastar.com>
Subject: Re: Moving DB data disk to a different machine
Cc: pgsql-admin@postgresql.org
In-Reply-To: 
 <5C27B2F8693FA3458E71B4A81551253F03A3C6E5@NSTAR-MAIL1.windows.nagrastar.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: 
 <5C27B2F8693FA3458E71B4A81551253F03A3C6E5@NSTAR-MAIL1.windows.nagrastar.com>

On Mon, Sep 15, 2008 at 1:09 PM, Eliot, Christopher
<christopher.eliot@nagrastar.com> wrote:
> I have a database that I use for testing.  The contents are not particularly
> critical; if I were to lose that data, it would be an annoyance but not a
> disaster.  Thus I do not back up the DB.
>
> 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.
>
> After installing PostgreSQL 8.2 (what we had been using) on this new
> workstation, I tried simply copying the 'Program Files\Postgresql\8.2\data'
> directory over from the old disk to the new, but the result is that when I
> try to bring up the PostgreSQL server, it takes a long time, and then goes
> down.

You need to empty out the postgresql data directory, then copy
everything in from the other disk.  What errors are you getting?  It's
possible you're not using a compatible version.

The major version numbers need to match (i.e. 8.2.4 to 8.2.7 is fine,
8.1.13 to 8.2.7 is not) and they need to be compiled the same way.
I.e. if you had integer timestamps in one you need it in the other.