Skip site navigation (1) Skip section navigation (2)

BUG #6034: pg_upgrade fails when it should not.

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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.

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-05-23 01:00:59
Subject: Re: timezone GUC
Previous:From: Robert HaasDate: 2011-05-22 22:10:54
Subject: Re: eviscerating the parser

pgsql-bugs by date

Next:From: Craig RingerDate: 2011-05-23 01:20:38
Subject: Re: BUG #6032: server fail to connect
Previous:From: Martin PittDate: 2011-05-22 14:19:21
Subject: [PATCH] ident authentication fails on kFreeBSD/x86-64 due to wrong struct size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group