From: Mathias Breuninger <mathias.breuninger@espace29.asso.fr>
To: pgsql-admin@postgresql.org
Subject: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
Date: Tue, 4 Sep 2012 10:04:49 +0200
Message-ID: <002801cd8a73$f4c648c0$de52da40$@breuninger@espace29.asso.fr> (raw)
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.
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
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: mathias.breuninger@espace29.asso.fr
Subject: Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error
In-Reply-To: <002801cd8a73$f4c648c0$de52da40$@breuninger@espace29.asso.fr>
* 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