On 27/10/10 08:34, Dann Corbit wrote: >> -----Original Message----- >> From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- >> owner@xxxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx >> Subject: Re: 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
