Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <peter_e@gmx.net>) id 1TFlNi-0006KA-Td
	for pgsql-hackers@postgresql.org; Sun, 23 Sep 2012 12:33:54 +0000
Received: from mailout-de.gmx.net ([213.165.64.23])
	by magus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <peter_e@gmx.net>) id 1TFlNg-0002uK-T3
	for pgsql-hackers@postgresql.org; Sun, 23 Sep 2012 12:33:54 +0000
Received: (qmail invoked by alias); 23 Sep 2012 12:33:50 -0000
Received: from pool-108-52-108-60.phlapa.fios.verizon.net (EHLO [192.168.1.4])
	[108.52.108.60]
	by mail.gmx.net (mp029) with SMTP; 23 Sep 2012 14:33:50 +0200
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX19iyadY5R9iEaSv/fNin0r4btxmDkJzQ1sDZvSaQC
	fJaJgCUGn6d86s
Message-ID: <1348403628.18490.1.camel@vanquo.pezone.net>
Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed
From: Peter Eisentraut <peter_e@gmx.net>
To: Rural Hunter <ruralhunter@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, PostgreSQL-development
	<pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: Sun, 23 Sep 2012 08:33:48 -0400
In-Reply-To: <505C307E.20501@gmail.com>
References: <50535302.8080000@gmail.com> <20120914183915.GA5933@momjian.us>
	<5053F896.60005@gmail.com> <20120915180603.GA20907@momjian.us>
	<505557CD.8090304@gmail.com> <20120916171746.GA24907@momjian.us>
	<28666.1347833056@sss.pgh.pa.us> <20120917043236.GA20123@momjian.us>
	<5056AF29.3040903@gmail.com> <20120917210723.GA30394@momjian.us>
	<20120918232239.GA2014@momjian.us> <505C307E.20501@gmail.com>
Content-Type: text/plain; charset="UTF-8"
X-Mailer: Evolution 3.4.3-1 
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
X-Y-GMX-Trusted: 0
X-Pg-Spam-Score: -2.7 (--)
X-Archive-Number: 201209/839
X-Sequence-Number: 213867

On Fri, 2012-09-21 at 17:16 +0800, Rural Hunter wrote:
> If I run initdb with '-E zh_CN.utf8', it will tell me there 
> is no such charset in the system.

Because that is the name of a locale, not an encoding.

>  I found a workaround to run initdb 
> with '--lc-collate=zh_CN.utf8 --lc-ctype=zh_CN.utf8 
> --lc-messages=zh_CN.utf8 --lc-monetary=zh_CN.utf8 
> --lc-numeric=zh_CN.utf8 --lc-time=zh_CN.utf8'. But the case problem is
> really confusing. 

Try initdb --locale='zn_CN.utf8'.