Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGApw-0006eh-NK for pgsql-hackers@postgresql.org; Mon, 24 Sep 2012 15:44:44 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGApt-0001os-4t for pgsql-hackers@postgresql.org; Mon, 24 Sep 2012 15:44:44 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q8OFiaVX016082; Mon, 24 Sep 2012 11:44:36 -0400 (EDT) From: Tom Lane To: Bruce Momjian cc: Peter Eisentraut , Rural Hunter , PostgreSQL-development Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed In-reply-to: <20120924153039.GH21242@momjian.us> References: <1348403628.18490.1.camel@vanquo.pezone.net> <505F1A98.9090901@gmail.com> <1348440393.18490.2.camel@vanquo.pezone.net> <20120924125500.GA21242@momjian.us> <50606726.3050802@gmail.com> <20120924142659.GC21242@momjian.us> <5060720E.1080903@gmail.com> <20120924145731.GE21242@momjian.us> <15359.1348499072@sss.pgh.pa.us> <50607AAE.70400@gmx.net> <20120924153039.GH21242@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Mon, 24 Sep 2012 11:30:40 -0400" Date: Mon, 24 Sep 2012 11:44:36 -0400 Message-ID: <16081.1348501476@sss.pgh.pa.us> X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201209/894 X-Sequence-Number: 213922 Bruce Momjian writes: > On Mon, Sep 24, 2012 at 11:22:22AM -0400, Peter Eisentraut wrote: >> 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. It was not just a refactoring: we now pass the locale names through setlocale() which we didn't before. See commit c7cea267de3ca05b29a57b9d113b95ef3793c8d8. regards, tom lane