Re: LC_COLLATE and pg_upgrade - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: LC_COLLATE and pg_upgrade
Date
Msg-id 1297857285.8578.1.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: LC_COLLATE and pg_upgrade  (Bernhard Schrader <bernhard.schrader@innogames.de>)
Responses Re: LC_COLLATE and pg_upgrade  (Bernhard Schrader <bernhard.schrader@innogames.de>)
List pgsql-admin
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.



pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: cp1250 problem
Next
From: Bernhard Schrader
Date:
Subject: Re: LC_COLLATE and pg_upgrade