On Tue, Mar 15, 2005 at 02:29:51PM +0100, NTPT wrote: > I have situation where I have one box with linux native 64 bit > distribution (Gentoo on AMD) running pg 8.x and other box running a 32 bit > distro running version of pg 8.x > > Is it posssible to take a "filesystem level backup" (copyiing all in > $PGDATA directory) from 64 bit system and use it as $PGDATA in the native > 32 bit system with the same version of postgresql ?
Doubt it, it's not explicitly supported. It might work, but padding changes, certain width changes, may screw you up. > Ie to have one big 64 bit server and eventually a small but cheap 32 bit > box as an emergency backup ? Use something like Slony, it's specifically supports this kind of usage... Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> 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.
pgpksLawR0pa6.pgp
Description: PGP signature
