From owner-freebsd-ppc@FreeBSD.ORG Wed Sep 5 08:03:36 2012 Return-Path: Delivered-To: freebsd-ppc@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3BE291065780 for ; Wed, 5 Sep 2012 08:03:36 +0000 (UTC) (envelope-from mathias.breuninger@espace29.asso.fr) Received: from smtp-out05.msg.oleane.net (smtp-out05.msg.oleane.net [62.161.7.3]) by mx1.freebsd.org (Postfix) with ESMTP id AD0A88FC17 for ; Wed, 5 Sep 2012 08:03:35 +0000 (UTC) Received: from smtp06.msg.oleane.net (smtp06.mail.priv [172.17.20.115]) by smtp-out05.msg.oleane.net with ESMTP id q8583R6l002973 for ; Wed, 5 Sep 2012 10:03:28 +0200 Received: from formation5 (201-98.83-90.static-ip.oleane.fr [90.83.98.201]) (authenticated) by smtp06.msg.oleane.net (MSA) with ESMTP id q857hCcJ024893 for ; Wed, 5 Sep 2012 09:43:12 +0200 X-Oleane-Rep: REPA From: "Mathias Breuninger" To: References: <5045b69d.83ac0e0a.36e7.354dSMTPIN_ADDED@mx.google.com> <5046764E.4050603@ringerc.id.au> In-Reply-To: <5046764E.4050603@ringerc.id.au> Date: Wed, 5 Sep 2012 09:43:12 +0200 Organization: Espace Associatif Message-ID: <003101cd8b3a$1a16d380$4e447a80$@breuninger@espace29.asso.fr> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac2K5oV4D587IREXSoWf8l0SsM2dDwAT7dZg Content-Language: fr X-Spam-Flag: NO X-PMX-Spam: Probability=8% X-PFSI-Info: PMX 5.6.0.2009776, Antispam-Engine: 2.7.2.376379, Antispam-Data: 2012.9.5.72727 (no antivirus check) X-Orange-Auth: bWF0aGlhcy5icmV1bmluZ2VyQGVzcGFjZTI5LmFzc28uZnI= Subject: RE: [ADMIN] Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error X-BeenThere: freebsd-ppc@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting FreeBSD to the PowerPC List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Sep 2012 08:03:36 -0000 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