Re: [GENERAL] Datafiles binary portable?

2006-11-28 Thread Martijn van Oosterhout
On Tue, Nov 28, 2006 at 11:00:35AM -0500, Stephen Harris wrote: > This is probably a silly question, but are the database files binary portable? > eg could I take datafiles from a Sparc and copy them to an Intel machine, > or would the endianness differences kill me? No. It may not even be compat

Re: [GENERAL] Datafiles binary portable?

2006-11-28 Thread Tom Lane
Stephen Harris <[EMAIL PROTECTED]> writes: > This is probably a silly question, but are the database files binary portable? No. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Datafiles binary portable?

2006-11-28 Thread Richard Huxton
Stephen Harris wrote: This is probably a silly question, but are the database files binary portable? No eg could I take datafiles from a Sparc and copy them to an Intel machine, or would the endianness differences kill me? Yes How about cross OS (eg from Linux Intel to Windows XP, or from

[GENERAL] Datafiles binary portable?

2006-11-28 Thread Stephen Harris
This is probably a silly question, but are the database files binary portable? eg could I take datafiles from a Sparc and copy them to an Intel machine, or would the endianness differences kill me? I expect the answer to be "funny man! Of course not!" for reasons of speed (native interger handlin