Re: Moving DB data disk to a different machine - Mailing list pgsql-admin

From Eliot, Christopher
Subject Re: Moving DB data disk to a different machine
Date
Msg-id 5C27B2F8693FA3458E71B4A81551253F03A3C75B@NSTAR-MAIL1.windows.nagrastar.com
Whole thread Raw
In response to Re: Moving DB data disk to a different machine  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
Yes, in fact I installed postgreSQL, renamed the newly-created "data"
directory, and then copied over the old data directory.
When that didn't work I renamed my new data directory off to another
name and restored the data directory that was created as part of the
installation, and was able to successfully bring up the server.

I'll look in to the pg_controldata thing you suggested.

Topher Eliot
christopher.eliot@nagrastar.com
[]

> -----Original Message-----
> From: Scott Marlowe [mailto:scott.marlowe@gmail.com]


>
> 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.
>

pgsql-admin by date:

Previous
From: Trent Pingenot
Date:
Subject: Permissions Scenerio
Next
From: Tom Lane
Date:
Subject: Re: Permissions Scenerio