Re: PostgreSQL 32 bit DB on 64 bit machine

On 27/10/10 08:34, Dann Corbit wrote:
>> -----Original Message-----
>> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
>> owner@postgresql.org] On Behalf Of Joshua D. Drake
>> Sent: Tuesday, October 26, 2010 5:18 PM
>> To: Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] PostgreSQL 32 bit DB on 64 bit machine
>>
>> On Tue, 2010-10-26 at 18:53 -0500, Martin, Brian D. (JSC-OD)[UNITED
>> SPACE ALLIANCE LLC] wrote:
>>> Can a 32 bit PostgreSQL v. 9.0 db be copied from a 32 bit machine and
>> overwrite the db on a 64 bit PostgreSQL machine?  I'm trying to get a
>> good initial starting point before performing hot standy write ahead
>> logging (WAL) replication between a 32 bit and 64 bit machine.  When I
>> copy the 32 bit db to the 64 bit db, the PostgreSQL logs are saying the
>> pg_control file has a checksum mis-match.  When I backup and restore
>> the 64 bit pg_control then the log files report a sys id mismatch.
>>>
>>
>> You must run the same architecture.... 32-32 or 64-64

It's also possible to run 32-bit PostgreSQL binaries on a 64-bit
machine. In that case, a 32-bit data directory may be used.

> I think he can get what he wants by doing a SQL dump instead of an ordinary dump.

I tend to agree. Running a 32-bit DB on the 64-bit host won't tell them
anything much for this case.

--
Craig Ringer

Tech-related writing: http://soapyfrogs.blogspot.com/