Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Sep 4, 2012 at 12:04 PM, Mathias Breuninger
<mathias.breuninger@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
> 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.ru@xxxxxxxxx Skype: gray-hemp Phone: +79160686204


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux