>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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Em nome de Hannes Erven Enviada em: terça-feira, 20 de setembro de 2011 17:26 Para: pgsql Assunto: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
