Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 32 bit DB on 64 bit machine - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: PostgreSQL 32 bit DB on 64 bit machine
Date
Msg-id 1288138696.2126.62.camel@jd-desktop
Whole thread Raw
In response to PostgreSQL 32 bit DB on 64 bit machine  ("Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]" <brian.d.martin@nasa.gov>)
Responses Re: PostgreSQL 32 bit DB on 64 bit machine  (Dann Corbit <DCorbit@connx.com>)
List pgsql-general
Tree view 
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)
replicationbetween a 32 bit and 64 bit machine.  When I copy the 32 bit db to the 64 bit db, the PostgreSQL logs are
sayingthe pg_control file has a checksum mis-match.  When I backup and restore the 64 bit pg_control then the log files
reporta 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

pgsql-general by date:

Previous
From: "Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]"
Date:
Subject: PostgreSQL 32 bit DB on 64 bit machine
Next
From: Dann Corbit
Date:
Subject: Re: PostgreSQL 32 bit DB on 64 bit machine