From: | Dann Corbit <DCorbit(at)connx(dot)com> |
---|---|
To: | "'jd(at)commandprompt(dot)com'" <jd(at)commandprompt(dot)com>, "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:34:16 |
Message-ID: | 87F42982BF2B434F831FCEF4C45FC33E4206926C@EXCHANGE.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Joshua D. Drake
> Sent: Tuesday, October 26, 2010 5:18 PM
> To: Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] PostgreSQL 32 bit DB on 64 bit machine
>
> 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
I think he can get what he wants by doing a SQL dump instead of an ordinary dump.
For instance, from PG Admin III, right click on the database cylinder and choose the plain text options. You'll be left with a command something like this:
pg_dump --host localhost --port 5433 --username postgres --format plain --create --clean --inserts --column-inserts --verbose --file "q:\donzbrane.sql" "Chess"
(Here, I am sending the output of a database called 'Chess' to a SQL file called donzbrane.sql).
By examining the options and command line choices for pg_dump from the manuals, you can also create exactly what you want.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2010-10-27 00:53:11 | Re: PostgreSQL 32 bit DB on 64 bit machine |
Previous Message | Joshua D. Drake | 2010-10-27 00:18:16 | Re: PostgreSQL 32 bit DB on 64 bit machine |