John R Pierce <pierce@xxxxxxxxxxxx> writes: > On 09/22/11 1:35 PM, Hannes Erven wrote: >> I'm still hoping someone would give me a clue why 32/64 bit platform >> xlogs are (and always will?) be absolutely incompatible... ??? > because the tuple representations are different, plain and simple. Specifically, the data alignment rules are different, so a 64-bit tuple can have padding bytes in it in places where a 32-bit tuple doesn't. This spills over into different numbers of tuples fitting on a page, etc etc. > you can run a 32bit Postgres on your 64bit platform. Yeah, that would be the thing to do if you're stuck with replicating to nonidentical hardware. 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
