Thread: on-disk format across architectures

Hi,

I'm aware that the on-disk format changes between releases. However,
I'd like to know if it also varies across architectures.

Specifically, my home directory is NFS-mounted and I'd like to be
able to run postmaster on both Sparc Solaris and Intel Linux
using the same -D option (obviously not at the same time!).

 cheers,
 Tom.

Please please please take me off this list!!


----- Original Message -----
From: "Tom JONES" <T.Jones@cs.ucl.ac.uk>
To: <pgsql-general@postgresql.org>
Sent: Monday, January 27, 2003 1:56 PM
Subject: [GENERAL] on-disk format across architectures


> Hi,
>
> I'm aware that the on-disk format changes between releases. However,
> I'd like to know if it also varies across architectures.
>
> Specifically, my home directory is NFS-mounted and I'd like to be
> able to run postmaster on both Sparc Solaris and Intel Linux
> using the same -D option (obviously not at the same time!).
>
>  cheers,
>  Tom.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Tom JONES <T.Jones@cs.ucl.ac.uk> writes:
> I'm aware that the on-disk format changes between releases. However,
> I'd like to know if it also varies across architectures.

Absolutely.  Endianness, alignment, and floating-point format are all
machine dependent.

> Specifically, my home directory is NFS-mounted and I'd like to be
> able to run postmaster on both Sparc Solaris and Intel Linux
> using the same -D option (obviously not at the same time!).

You lose, I'm afraid :-(

            regards, tom lane