From: "Mathias Breuninger" <mathias.breuninger@espace29.asso.fr>
To: <pgsql-admin@postgresql.org>
References: <5045b69d.83ac0e0a.36e7.354dSMTPIN_ADDED@mx.google.com>
	<5046764E.4050603@ringerc.id.au>
In-Reply-To: <5046764E.4050603@ringerc.id.au>
Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
Date: Wed, 5 Sep 2012 11:21:32 +0200
Organization: Espace Associatif
Message-ID: <004701cd8b47$d6a4b5f0$83ee21d0$@breuninger@espace29.asso.fr>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: 7bit
Thread-Index: Ac2K5oV4D587IREXSoWf8l0SsM2dDwAT7dZg
Content-Language: fr

On 09/04/2012 11:45 PM CEST, Craig Ringer wrote:
> > 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

Thank you for your answers.

I wasn't aware of the binary problem with replication.
Maybe the PostgreSQL docs should emphasize the architecture restriction.

I'll explore the other solutions.

--
Mathias