Re: Datafiles binary portable? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Datafiles binary portable?
Date
Msg-id 456C5FED.1040604@archonet.com
Whole thread Raw
In response to Datafiles binary portable?  (Stephen Harris <lists@spuddy.org>)
List pgsql-general
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 Solaris Intel
> to Linux Intel)?

Maybe. Wouldn't count on it though.

In fact the data files can be incompatible because of different
compile-time flags (64-bit integer dates on/off for example).
--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to increace nightly backup speed
Next
From: Karsten Hilbert
Date:
Subject: Re: How to implement backup protocol