postgresql 8.4 install failed on windows xp chinese PRC

From: 刘鑫 <march(dot)liu(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postgresql 8.4 install failed on windows xp chinese PRC
Date: 2009-07-02 03:47:56
Message-ID: d7bd4e1e0907012047j31dc44fpf09c8389f9bab625@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

F:\PostgreSQL\8.4\bin>initdb -U postgres --encoding=utf8 --locale=utf8
--lc-coll
ate='missing' F:\PostgresSQL\8.4\data
initdb: invalid locale name "utf8"
initdb: invalid locale name "'missing'"
initdb: invalid locale name "utf8"
initdb: invalid locale name "utf8"
initdb: invalid locale name "utf8"
initdb: invalid locale name "utf8"
The files belonging to this database system will be owned by user "刘鑫".
This user must also own the server process.

The database cluster will be initialized with locale Chinese_People's
Republic o
f China.936.
initdb: could not find suitable text search configuration for locale
Chinese_Peo
ple's Republic of China.936
The default text search configuration will be set to "simple".

creating directory F:/PostgresSQL/8.4/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in F:/PostgresSQL/8.4/data/base/1 ... ok
initializing pg_authid ... FATAL: database locale is incompatible with
operatin
g system
DETAIL: The database was initialized with LC_COLLATE "Chinese_Peoples
Republic
of China.936", which is not recognized by setlocale().
HINT: Recreate the database with another locale or install the missing
locale.
child process exited with exit code 1
initdb: removing data directory "F:/PostgresSQL/8.4/data"

I reinstall and set LC_COLLATE to English, Unite State. It success.

March.Liu

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Itagaki Takahiro 2009-07-02 04:02:10 Re: postgresql 8.4 install failed on windows xp chinese PRC
Previous Message Bruce Momjian 2009-07-02 01:55:26 Re: BUG #4894: [patch] documentation bug on 'include' directive