Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGAD8-0008T2-Ny for pgsql-hackers@postgresql.org; Mon, 24 Sep 2012 15:04:38 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGAD7-0004hl-Mq for pgsql-hackers@postgresql.org; Mon, 24 Sep 2012 15:04:38 +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 q8OF4Xue015360; Mon, 24 Sep 2012 11:04:33 -0400 (EDT) From: Tom Lane To: Bruce Momjian cc: Rural Hunter , Peter Eisentraut , PostgreSQL-development Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed In-reply-to: <20120924145731.GE21242@momjian.us> References: <20120917210723.GA30394@momjian.us> <20120918232239.GA2014@momjian.us> <505C307E.20501@gmail.com> <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> Comments: In-reply-to Bruce Momjian message dated "Mon, 24 Sep 2012 10:57:31 -0400" Date: Mon, 24 Sep 2012 11:04:32 -0400 Message-ID: <15359.1348499072@sss.pgh.pa.us> X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201209/887 X-Sequence-Number: 213915 Bruce Momjian 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. regards, tom lane