Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error

[Sergey Konoplev]

On Tue, Sep 4, 2012 at 12:04 PM, Mathias Breuninger

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.

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
--
http://www.postgresql.org/mailpref/pgsql-admin

--
Sergey Konoplev

a database architect, software developer at PostgreSQL-Consulting.com
http://www.postgresql-consulting.com

Jabber: ***@gmail.com Skype: gray-hemp Phone: [phone]

[Albe Laurenz]

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.
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.

You cannot have primary and standby server with different architectures.

Maybe should I go with Slony-I as it seems to work with differents architectures.

That's an option.

Yours,
Laurenz Albe

[Craig Ringer]

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

[Craig James]

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.

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.

Craig