From: Mathias Breuninger <mathias.breuninger@espace29.asso.fr>
To: pgsql-admin@postgresql.org
Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
Date: Wed, 5 Sep 2012 11:21:32 +0200
Message-ID: <004701cd8b47$d6a4b5f0$83ee21d0$@breuninger@espace29.asso.fr> (raw)
In-Reply-To: <5046764E.4050603@ringerc.id.au>
References: <5045b69d.83ac0e0a.36e7.354dSMTPIN_ADDED@mx.google.com>
<5046764E.4050603@ringerc.id.au>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mathias.breuninger@espace29.asso.fr
Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
In-Reply-To: <004701cd8b47$d6a4b5f0$83ee21d0$@breuninger@espace29.asso.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox