FS#26216 - [postgresql] Upgrade from 9.0.4 to 9.1.1

Attached to Project: Arch Linux
Opened by Tom (mdevilz) - Sunday, 02 October 2011, 23:44 GMT
Last edited by Dan McGee (toofishes) - Monday, 03 October 2011, 14:57 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Paul Mattal (paul)
Dan McGee (toofishes)
Architecture x86_64
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description: When upgrading from Postgresql 9.0.4 to 9.1.1 using postgresql-old-upgrade I get the following error:

Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions
This utility can only upgrade to PostgreSQL version 9.1.
Failure, exiting


Steps to reproduce:
[postgres@comp ~]$ /usr/bin/pg_upgrade -d /var/lib/postgres/data.old/ -D /var/lib/postgres/data/ -b /opt/pgsql-9.0/bin/ -B /usr/bin/
This task depends upon

Closed by  Dan McGee (toofishes)
Monday, 03 October 2011, 14:57 GMT
Reason for closing:  Not a bug
Additional comments about closing:  See last comment.
Comment by Dan McGee (toofishes) - Monday, 03 October 2011, 14:33 GMT
Did you upgrade your regular postgresql binaries? Did you move your data directory to data.old *before* running pg_upgrade, and then initialize a new cluster with 9.1?
Comment by Tom (mdevilz) - Monday, 03 October 2011, 14:50 GMT
I upgrade using pacman -Syu, which installed postgresql 9.1.1, and then I installed postgresql-old-upgrade.

I copied the data directory (did I need to move it) to data.old, and I tried running pg_upgrade with the switches listed above.
Comment by Dan McGee (toofishes) - Monday, 03 October 2011, 14:57 GMT
Copying will NOT work. Please read in full the pg_upgrade instructions, and I believe this is noted on the Arch wiki as well.

Loading...