Re: LC_COLLATE and pg_upgrade

On mån, 2011-02-14 at 14:18 +0100, Bernhard Schrader wrote:
> As far as I read right now, LC_COLLATE is a read_only variable which
> is used while initdb. But why does the pg_upgrade script doesn't see
> that utf8 and UTF-8 are the same? Is it just a string compare?

Why don't you just reinitialize your new database cluster with the same
locale spelling as the old one?

Your points are valid, but unfortunately difficult to handle in the
general case.