PostgreSQL 32 bit DB on 64 bit machine

From: "Martin, Brian D(dot) (JSC-OD)[UNITED SPACE ALLIANCE LLC]" <brian(dot)d(dot)martin(at)nasa(dot)gov>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL 32 bit DB on 64 bit machine
Date: 2010-10-26 23:53:29
Message-ID: 8C528C56EFCFCD4C8CA8CAA85406E933AEA7295C58@NDJSSCC04.ndc.nasa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thank you,
Brian Martin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-10-27 00:18:16 Re: PostgreSQL 32 bit DB on 64 bit machine
Previous Message Alban Hertroys 2010-10-26 22:45:57 Re: DB become enormous with continuos insert and update