Re: Filesystem level backup and 32 / 64 bit

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(at)svana(dot)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.