Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Mathias Breuninger <mathias(dot)breuninger(at)espace29(dot)asso(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
Date: 2012-09-04 21:44:46
Message-ID: 5046764E.4050603@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 09/04/2012 06:04 PM, Mathias Breuninger wrote:
> Hi,
>
> I configure PostgreSQL 9.1.5 on two servers: one with FreeBSD-9.0/powerpc64 and the other with FreeBSD-9.0/powerpc.
>
> The 64 bits server is the master and I tried to configure the 32 bits one as a standby server.

That isn't a supported configuration. The standby needs to be the same
architecture as the master and needs to use the same compilation options.

I'm surprised the error message wasn't more useful in this case.

> I can recompile PostgreSQL on the 64bit architecture without this configure option, but I wonder if there will be a performance drawback.

It still won't work. If you want to replicate from a 64-bit machine to a
32-bit machine you will need to build a 32-bit version of PostgreSQL on
the 64-bit machine.

--
Craig Ringer

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Haas 2012-09-05 03:07:00 Re: Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)
Previous Message Bob Lunney 2012-09-04 20:57:39 Re: Schema diagramming tool?