Thread: postgresql 8.4 install failed on windows xp chinese PRC

postgresql 8.4 install failed on windows xp chinese PRC

From
刘鑫
Date:
system : windows xp Chinese simple<br />postgres : postgresql-8.4.0-1-windows.exe<br /><br />installl processing and
errors:<br/><br />install failed by one click installer, then I run initdb.<br /><br />F:\PostgreSQL\8.4\bin>initdb
-Upostgres --encoding=utf8 --locale=utf8 --lc-coll<br /> ate='missing' F:\PostgresSQL\8.4\data<br />initdb: invalid
localename "utf8"<br />initdb: invalid locale name "'missing'"<br />initdb: invalid locale name "utf8"<br />initdb:
invalidlocale name "utf8"<br /> initdb: invalid locale name "utf8"<br />initdb: invalid locale name "utf8"<br />The
filesbelonging to this database system will be owned by user "刘鑫".<br />This user must also own the server process.<br
/><br/>The database cluster will be initialized with locale Chinese_People's Republic o<br />f China.936.<br />initdb:
couldnot find suitable text search configuration for locale Chinese_Peo<br />ple's Republic of China.936<br /> The
defaulttext search configuration will be set to "simple".<br /><br />creating directory F:/PostgresSQL/8.4/data ...
ok<br/>creating subdirectories ... ok<br />selecting default max_connections ... 100<br />selecting default
shared_buffers... 32MB<br /> creating configuration files ... ok<br />creating template1 database in
F:/PostgresSQL/8.4/data/base/1... ok<br />initializing pg_authid ... FATAL: database locale is incompatible with
operatin<br/>g system<br />DETAIL: The database was initialized with LC_COLLATE "Chinese_Peoples Republic<br /> of
China.936",which is not recognized by setlocale().<br />HINT: Recreate the database with another locale or install the
missinglocale.<br />child process exited with exit code 1<br />initdb: removing data directory
"F:/PostgresSQL/8.4/data"<br/><br />I reinstall and set LC_COLLATE to English, Unite State. It success.<br /><br
/>March.Liu<br/> 

Re: postgresql 8.4 install failed on windows xp chinese PRC

From
Itagaki Takahiro
Date:
?? <march.liu@gmail.com> wrote:

> system : windows xp Chinese simple
> postgres : postgresql-8.4.0-1-windows.exe
> F:\PostgreSQL\8.4\bin>initdb -U postgres --encoding=utf8 --locale=utf8

It's not a bug, just "utf8" is not a valid locale name.
Use the following instead:
$ initdb --encoding=UTF8 --locale="Chinese (Simplified)"

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center

Re: postgresql 8.4 install failed on windows xp chinese PRC

From
Sachin Srivastava
Date:
On 07/02/2009 09:17 AM, 刘鑫 wrote:
> system : windows xp Chinese simple
> postgres : postgresql-8.4.0-1-windows.exe
>
> installl processing and errors:
>
> install failed by one click installer, then I run initdb.
Can you please post the error part in the install logs present in your
system's temp directory (%TEMP%\install-postgresql.log) ?

--
Regards,
Sachin Srivastava
www.enterprisedb.com