Re: Datafiles binary portable?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Stephen Harris <lists(at)spuddy(dot)org>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Datafiles binary portable?
Date: 2006-11-28 16:12:29
Message-ID: 456C5FED.1040604@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2006-11-28 16:13:35 Re: How to implement backup protocol
Previous Message Andrus 2006-11-28 16:11:47 Re: How to increace nightly backup speed