pg_upgrade problem from 8.4 to 9.2 problems on OSX
От | Charles Porter |
---|---|
Тема | pg_upgrade problem from 8.4 to 9.2 problems on OSX |
Дата | |
Msg-id | CA+s3HynG8qPcLVYUVziMctoD6mZQbryHXynWNvdiZAd0Wv_P0A@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
|
Список | 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
В списке pgsql-general по дате отправления: