Re: [GENERAL] Filesystem level backup and 32 / 64 bit
On Tue, 2005-03-15 at 07:29, 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 ? > > > Ie to have one big 64 bit server and eventually a small but cheap 32 bit box > as an emergency backup ? Following up on what Tom wrote, I'd suggest using Slony-I to keep the two machines in sync. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Filesystem level backup and 32 / 64 bit
Martijn van Oosterhout writes: > On Tue, Mar 15, 2005 at 02:29:51PM +0100, NTPT wrote: >> Is it posssible to take a "filesystem level backup" (copyiing all in=20 >> $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. It might work if the main server were compiled as a 32-bit application ... but AFAIK the Intel-ish 64bit architectures mostly suck in 32-bit emulation mode, so you'd not want to do that. It will almost certainly *not* work to just cram 64-bit files onto a 32-bit machine, because the file layout is dependent on MAXALIGN which will likely be different. > Use something like Slony, it's specifically supports this kind of > usage... Agreed. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] 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 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
[GENERAL] Filesystem level backup and 32 / 64 bit
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 ? Ie to have one big 64 bit server and eventually a small but cheap 32 bit box as an emergency backup ? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])