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
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 |