Vick Khera <vivek@xxxxxxxxx> writes: > On Wed, Oct 13, 2010 at 11:17 AM, Geoffrey Myers > <lists@xxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
