pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Craig Ringer <ringerc@ringerc.id.au>
To: Mathias Breuninger <mathias.breuninger@espace29.asso.fr>
Cc: pgsql-admin@postgresql.org
Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
Date: Wed, 05 Sep 2012 07:44:46 +1000
Message-ID: <5046764E.4050603@ringerc.id.au> (raw)
In-Reply-To: <5045b69d.83ac0e0a.36e7.354dSMTPIN_ADDED@mx.google.com>
References: <5045b69d.83ac0e0a.36e7.354dSMTPIN_ADDED@mx.google.com>

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




view thread (7+ messages)  latest in thread

Message-ID: <5046764E.4050603@ringerc.id.au>
Permalink:  ../5046764E.4050603@ringerc.id.au/
Also on:    postgresql.org/message-id/5046764E.4050603@ringerc.id.au

 · 

reply

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: ringerc@ringerc.id.au, mathias.breuninger@espace29.asso.fr
  Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
  In-Reply-To: <5046764E.4050603@ringerc.id.au>

* 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