John R Pierce <pierce@hogranch.com> 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