Re: Replication between 64/32bit systems? - Mailing list pgsql-general

From Chris Travers
Subject Re: Replication between 64/32bit systems?
Date
Msg-id CAKt_ZfsT9FBMx-h6XH9p8U7HZxUmJcC3pVaHzSgx=tsecD46SA@mail.gmail.com
Whole thread Raw
In response to Re: Replication between 64/32bit systems?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
On Thu, Sep 22, 2011 at 5:46 PM, Craig Ringer <ringerc@ringerc.id.au> wrote:
> On 09/23/2011 04:35 AM, Hannes Erven wrote:
>>
>> thank you for your replies -- unfortunately, I'm not very content with
>> "it simply won't work" without understanding what the reasons are. ;-)
>>
>> Endianness, OK, but that's the same on i32/64 platforms. So is it just
>> the length of the int&  friends data types? I don't (yet) believe
>> there's no way around that.
>
> Theoretically, code could be written that understood the 32-bit form and
> translated it to the 64-bit form or vice versa. AFAIK no such code has been
> written and I don't think anyone's particularly interested in doing it.

Not if the number of tuples per page is different, unless one wants to
arbitrarily limit that, with attendant performance costs.....

Best Wishes,
Chris Travers

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Replication between 64/32bit systems?
Next
From: "Dickson S. Guedes"
Date:
Subject: Re: how to install 9.1 on non-graphical server?