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
