Re: Moving DB data disk to a different machine

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(dot)eliot(at)nagrastar(dot)com
[]

> -----Original Message-----
> From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)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.
>