pg_upgrade problem from 8.4 to 9.2 problems on OSX

From: Charles Porter <charles(dot)porter(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_upgrade problem from 8.4 to 9.2 problems on OSX
Date: 2013-01-16 23:06:41
Message-ID: CA+s3HynG8qPcLVYUVziMctoD6mZQbryHXynWNvdiZAd0Wv_P0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-01-16 23:23:43 Re: argument of AND must not return a set when using regexp_matches
Previous Message Steve Atkins 2013-01-16 22:45:17 Re: Best method to compare subdomains