Re: pitr question - Mailing list pgsql-general

From Tom Lane
Subject Re: pitr question
Date
Msg-id 27214.1286985182@sss.pgh.pa.us
Whole thread Raw
In response to Re: pitr question  (Vick Khera <vivek@khera.org>)
List pgsql-general
Vick Khera <vivek@khera.org> writes:
> On Wed, Oct 13, 2010 at 11:17 AM, Geoffrey Myers
> <lists@serioustechnology.com> wrote:
>>> 'In any case the hardware architecture must be the same � shipping from,
>>> say, a 32-bit to a 64-bit system will not work.'

>> Is this specific to the hardware? �That is to say, can I use pitr wal
>> shipping from 64 bit hardware to 64 bit hardware, where one machine is
>> running a 32 bit OS and the other is running a 64 bit OS?

> It applies to the OS.  The OS determines the sizes of integers,
> padding alignment, etc.  Running 32-bit OS on an amd64 class processor
> is the same as running it on a x86 class processor.  Other processors
> (such as PowerPC) may behave differently, I don't know.

It's not really the OS but the build of Postgres.  Most 64-bit OSes are
perfectly capable of running 32-bit executables.  You can ship WAL from
one machine running a 32-bit Postgres executable to another one running
a 32-bit executable (of the same hardware architecture), regardless of
whether the hardware or the OS is 64-bit-capable on either end.  But you
can't ship WAL between 32-bit and 64-bit executables.

            regards, tom lane

pgsql-general by date:

Previous
From: Geoffrey Myers
Date:
Subject: Re: pitr question
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pitr question