Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed

On Mon, Sep 24, 2012 at 11:22:22AM -0400, Peter Eisentraut wrote:
> On 9/24/12 11:04 AM, Tom Lane wrote:
> > Bruce Momjian <bruce(at)momjian(dot)us> writes:
> >> Well, if you run that query on template0 in the old and new cluster, you
> >> will see something different in the two of them. Could you have used
> >> default in one and a non-dash in the other. Did we change the way we
> >> canonicalize the locale between 9.1 and 9.2?
> >
> > IIRC, we didn't try to canonicalize locale names at all before 9.2.
> > That initdb code you're quoting is of fairly recent vintage.
>
> initdb has changed POSIX to C with glibc at least since 8.3. The code
> you're quoting is just a refactoring, AFAICT.

Frankly, I assumed the values assigned in pg_database for template0 were
canonical. Tom is saying that canonicalization behavior changed
between 9.1 to 9.2, and the user is reporting this.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +