Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 5 Sep 2012 09:43:12 +0200
From:      "Mathias Breuninger" <mathias.breuninger@espace29.asso.fr>
To:        <freebsd-ppc@freebsd.org>
Subject:   RE: [ADMIN] Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
Message-ID:  <003101cd8b3a$1a16d380$4e447a80$@breuninger@espace29.asso.fr>
In-Reply-To: <5046764E.4050603@ringerc.id.au>
References:  <5045b69d.83ac0e0a.36e7.354dSMTPIN_ADDED@mx.google.com> <5046764E.4050603@ringerc.id.au>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?003101cd8b3a$1a16d380$4e447a80$>