BUG #6034: pg_upgrade fails when it should not.

The following bug has been logged online:

Bug reference: 6034
Logged by: Tim Uckun
Email address: timuckun(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system: ubuntu linux
Description: pg_upgrade fails when it should not.
Details:

pg_upgrade from 8.4 to 9.0 fails with the following error message.

old and new cluster lc_collate values do not match

on 8.4 show lc_collate outputs
------------
en_NZ.utf8
(1 row)

on 9.0 it outputs
------------
en_NZ.UTF8
(1 row)

So the difference seems to be in capitalization. Presumably they are the
same collation with "different" names so it strikes me as odd that
pg_upgrade would balk and refuse to upgrade the database.

pg_upgrade should be able to tell that these are the same collations and go
ahead with the upgrade.

It also should give some indication of how to overcome the problem.