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 <kleptog@xxxxxxxxx> 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.
Attachment:
pgpzWOJM4Pfkb.pgp
Description: PGP signature
