> -----Original Message----- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.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@postgresql.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
