Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9W5H-0000Cj-Rt for pgsql-admin@postgresql.org; Thu, 06 Sep 2012 07:01:03 +0000 Received: from smtp06.msg.oleane.net ([62.161.4.6]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T9W5F-0007YW-OB for pgsql-admin@postgresql.org; Thu, 06 Sep 2012 07:01:02 +0000 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 q8670wmf007123 for ; Thu, 6 Sep 2012 09:00:58 +0200 X-Oleane-Rep: REPA From: "Mathias Breuninger" To: References: <5045b69d.83ac0e0a.36e7.354dSMTPIN_ADDED@mx.google.com> <5046764E.4050603@ringerc.id.au> <50471a01.83ac0e0a.3a58.4281SMTPIN_ADDED@mx.google.com> In-Reply-To: Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Date: Thu, 6 Sep 2012 09:00:58 +0200 Organization: Espace Associatif Message-ID: <003c01cd8bfd$5e1cb9a0$1a562ce0$@breuninger@espace29.asso.fr> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac2LdvU2WniMr5mETZ+KOJP8wVzowAAhY+CQ 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.6.64219 (no antivirus check) X-Orange-Auth: bWF0aGlhcy5icmV1bmluZ2VyQGVzcGFjZTI5LmFzc28uZnI= X-Pg-Spam-Score: -0.9 (/) X-Archive-Number: 201209/19 X-Sequence-Number: 39960 On 09/05/2012 4:59 PM, Craig James wrote: > On Wed, Sep 5, 2012 at 2:21 AM, Mathias Breuninger > > I wasn't aware of the binary problem with replication. > > Maybe the PostgreSQL docs should emphasize the architecture > restriction. >=20 > That's sort of what "binary file" means -- a raw, = architecture-specific > representation of data that's optimized for performance and/or space, > not portability. >=20 > Craig In fact, it is written clearly in the docs (25.2.1 Planning: " In any = case the hardware architecture must be the same =E2=80=94 shipping from, = say, a 32-bit to a 64-bit system will not work."), but I missed it. So I apologize for the annoyance. Regards. -- Mathias