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/>
