Re: Moving DB data disk to a different machine

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

 



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@xxxxxxxxxxxxx
[]

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

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


[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