From: | "Mathias Breuninger" <mathias(dot)breuninger(at)espace29(dot)asso(dot)fr> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error |
Date: | 2012-09-04 08:04:49 |
Message-ID: | 002801cd8a73$f4c648c0$de52da40$@breuninger@espace29.asso.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Konoplev | 2012-09-04 09:15:58 | Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error |
Previous Message | David Morton | 2012-09-03 22:01:17 | PG 9.1 Looking for old WAL when promoting from recovery to master |