| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | "Martin, Brian D(dot) (JSC-OD)[UNITED SPACE ALLIANCE LLC]" <brian(dot)d(dot)martin(at)nasa(dot)gov> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 32 bit DB on 64 bit machine |
| Date: | 2010-10-27 00:18:16 |
| Message-ID: | 1288138696.2126.62.camel@jd-desktop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2010-10-27 00:34:16 | Re: PostgreSQL 32 bit DB on 64 bit machine |
| Previous Message | Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC] | 2010-10-26 23:53:29 | PostgreSQL 32 bit DB on 64 bit machine |