Re: Recovery after server crash

On Sun, Oct 23, 2005 at 12:31:33PM -0500, Chris wrote:
> Good afternoon, all:
> 
> I recently experienced a server crash.  I have a backup of my Postgesql
> data directory.  
> 
> On rebuilding my machine, I decided to go with i386 instead of my
> original AMD64.  That means I now have a newer version of Postgresql
> available to me.  My original was 7.4 and my new is 8.0.3.  
> 
> How can I get my data from this 7.4 data directory into my 8.0.3 fresh
> install?  

You can't. In general the raw data structures are not portable between
versions and *definitly* not portable between architechtures.

You need to install the original version, pg_dump the data and then
load that into your new version...

Have a nice day,
-- 
Martijn van Oosterhout      http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.