Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Rural Hunter <ruralhunter(at)gmail(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed
Date: 2012-09-23 12:33:48
Message-ID: 1348403628.18490.1.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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'.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rural Hunter 2012-09-23 14:20:08 Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed
Previous Message Craig Ringer 2012-09-22 08:46:28 Re: Windows Services and Postgresql 9.1.3

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira 2012-09-23 13:56:14 Re: [PoC] load balancing in libpq
Previous Message Satoshi Nagayasu 2012-09-23 10:50:59 [PoC] load balancing in libpq