On Wed, Jan 16, 2013 at 03:06:41PM -0800, Charles Porter wrote: > I am trying to migrate from 8.4 to 9.2 on OSX 10.8 (Mountain Lion) > > Both 8.4 and 9.2 have been installed with the installers for OSX from > EnterpriseDB > > Both have been stopped. > > As user postgres, I run the pg_upgrade command and get the error > 'old and new pg_controldata alignments are invalid or do not match' > > Is there anything I can do to correct this? > > The 8.4 installation contains a lot of databases, so I would rather not do > pg_dump/pg_restore on every database unless necessary. > > This is the actual command and output: > > [/Volumes/DISK2/Postgres/9.2/data]$ /Library/PostgreSQL/9.2/bin/pg_upgrade \ > -b /Library/PostgreSQL8.4/bin \ > -B /Library/PostgreSQL/9.2/bin \ > -d /Library/PostgreSQL8.4/data \ > -D /Volumes/DISK2/Postgres/9.2/data > > > Performing Consistency Checks > ----------------------------- > Checking current, bin, and data directories ok > Checking cluster versions ok > > old and new pg_controldata alignments are invalid or do not match > Failure, exiting OK, sure. Run this on the old and new clusters: $ pg_controldata /u/pg/data.old $ pg_controldata /u/pg/data.new You will see a mismatch here: Maximum data alignment: 8 ^ My quick guess is that one is 32-bit mode and the other is 64-bit mode. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
