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
