From: | Sergey Konoplev <sergey(dot)konoplev(at)postgresql-consulting(dot)com> |
---|---|
To: | Mathias Breuninger <mathias(dot)breuninger(at)espace29(dot)asso(dot)fr> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error |
Date: | 2012-09-04 09:15:58 |
Message-ID: | CAL_0b1uGmFcBKP5BS1syw_AYrJjE--MvmPFBvcrrXacqJ0k6og@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Sep 4, 2012 at 12:04 PM, Mathias Breuninger
<mathias(dot)breuninger(at)espace29(dot)asso(dot)fr> wrote:
> 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.
It can not be run between different architectures and between
different major versions.
>
> I followed the documentation but I can't start the standby postgres daemon:
> postgres[73978]: [1-1] FATAL: database files are incompatible with server
> postgres[73978]: [1-2] DETAIL: The database cluster was initialized with USE_FLOAT8_BYVAL but the server was compiled without USE_FLOAT8_BYVAL.
> postgres[73978]: [1-3] HINT: It looks like you need to recompile or initdb.
>
> I can't find an option to initialize the database cluster without the USE_FLOAT8_BYVAL.
>
> I can recompile PostgreSQL on the 64bit architecture without this configure option, but I wonder if there will be a performance drawback.
>
> Maybe should I go with Slony-I as it seems to work with differents architectures.
>
> Have you a suggestion/solution?
>
> --
> Mathias
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Sergey Konoplev
a database architect, software developer at PostgreSQL-Consulting.com
http://www.postgresql-consulting.com
Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-09-04 09:27:28 | Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error |
Previous Message | Mathias Breuninger | 2012-09-04 08:04:49 | Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error |