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.
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
on 9.0 it outputs
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.
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2011-05-23 01:00:59|
|Subject: Re: timezone GUC|
|Previous:||From: Robert Haas||Date: 2011-05-22 22:10:54|
|Subject: Re: eviscerating the parser|
pgsql-bugs by date
|Next:||From: Craig Ringer||Date: 2011-05-23 01:20:38|
|Subject: Re: BUG #6032: server fail to connect|
|Previous:||From: Martin Pitt||Date: 2011-05-22 14:19:21|
|Subject: [PATCH] ident authentication fails on kFreeBSD/x86-64 due to wrong