From the manual, "In any case the hardware architecture must be the same
shipping from, say, a 32-bit to a 64-bit system will not work."...
I don't even believe you can copy a 64bit database into 32bit machine...
what makes warm standby impossible...
I've tried this in the past, and give up - without even contacting the list.
I was sure I was doing wrong. What I did was moving all my database servers
(I've 7: 2 production, 2 slaves, 2 development, 1 test release) into 64 bit
platform.
Other well known and equally respected databases poses same limitation (not
able to replicate from 32 to 64 or vice versa, or to other operating systems
due the "big endian"-"little endian" issue).
My2c,
Edson.
-----Mensagem original-----
De: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] Em nome de Hannes Erven
Enviada em: terça-feira, 20 de setembro de 2011 17:26
Para: pgsql
Assunto: [GENERAL] Replication between 64/32bit systems?
Hi folks,
I'm planning to set up streaming replication from one master to one slave.
I've read at http://www.postgresql.org/docs/9.1/static/warm-standby.html
that the "hardware architecture" of both systems must be the same.
Sure enough, what I'd really like to do is replicate from a Windows (or
Linux) 64bit master to a Linux 32bit slave -- that's what I currently have
easily available.
I tried just following the instructions and copied the data directory to the
slaves, but postgres does not start:
FATAL: falsche Prüfsumme in Kontrolldatei
(FATAL: wrong checksum in control file)
So I'd like to ask if there is anything I could do by e.g. changing
compile-time options at the slave to get things going?
Thank you for any advice!,
best regards
-hannes
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general