From: | "Tim Uckun" <timuckun(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6034: pg_upgrade fails when it should not. |
Date: | 2011-05-22 23:48:28 |
Message-ID: | 201105222348.p4MNmSwS024131@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2011-05-23 01:20:38 | Re: BUG #6032: server fail to connect |
Previous Message | Martin Pitt | 2011-05-22 14:19:21 | [PATCH] ident authentication fails on kFreeBSD/x86-64 due to wrong struct size |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-05-23 01:00:59 | Re: timezone GUC |
Previous Message | Robert Haas | 2011-05-22 22:10:54 | Re: eviscerating the parser |