Postgres Pro
Downloads
Home   >   mailing lists

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

From Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]"
Subject PostgreSQL 32 bit DB on 64 bit machine
Date
Msg-id 8C528C56EFCFCD4C8CA8CAA85406E933AEA7295C56@NDJSSCC04.ndc.nasa.gov
Whole thread Raw
Responses PostgreSQL 32 bit DB on 64 bit machine  ("Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]" <brian.d.martin@nasa.gov>)
List pgsql-general
Tree view 
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'mtrying to get a good initial starting point before performing hot standy write ahead logging (WAL) replication
betweena 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_controlfile has a checksum mis-match.  When I backup and restore the 64 bit pg_control then the log files report a
sysid mismatch. 

Thank you,
Brian Martin

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: DB become enormous with continuos insert and update
Next
From: "Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]"
Date:
Subject: PostgreSQL 32 bit DB on 64 bit machine