Re: pitr question

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