Re: Replication between 64/32bit systems?

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: Hannes Erven <hannes(at)erven(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: Replication between 64/32bit systems?
Date: 2011-09-23 01:11:50
Message-ID: CAKt_ZfsT9FBMx-h6XH9p8U7HZxUmJcC3pVaHzSgx=tsecD46SA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 22, 2011 at 5:46 PM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2011-09-23 03:38:14 Re: about synchronous_standby_names or sync replic
Previous Message Dickson S. Guedes 2011-09-23 01:11:29 Re: how to install 9.1 on non-graphical server?