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 > Thank you, > Brian Martin -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
