initdb failes on Traditional chinese machine when postgres install directory contains chinese characters.

From: "Sarkar, Sudipta" <Sudipta_Sarkar(at)bmc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: initdb failes on Traditional chinese machine when postgres install directory contains chinese characters.
Date: 2010-01-22 21:19:16
Message-ID: 2FB1D66ABE14B141BCF3DD40A3D95AD113A6C07987@PHXCCRPRD01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I downloaded postgres 8.4 in zip format and installed it under c:\postgres用名 on a traditional Chinese windows 2003 server. Note the Chinese characters in the folder name. Then I tried to create a database using initdb. I specified the following command:

initdb.exe --encoding UTF-8 -D c:\mydb\db --username user1 W L c:\postgres用名\share

The command failed with the following output. It failed while loading system objects description. The command works fine if I install postgres on a folder containg only ascii characters.

The files belonging to this database system will be owned by user "Administrator
".
This user must also own the server process.

The database cluster will be initialized with locale Chinese_Taiwan.950.
initdb: could not find suitable text search configuration for locale Chinese_Tai
wan.950
The default text search configuration will be set to "simple".

creating directory c:/BCA-Networks-Data/db ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 32MB/204800
creating configuration files ... ok
creating template1 database in c:/BCA-Networks-Data/db/base/1 ... ok
initializing pg_authid ... ok
Enter new superuser password:
Enter it again:
setting password ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... FATAL: invalid byte sequence for encoding "UTF8": 0xa5
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
child process exited with exit code 1
initdb: removing data directory "c:/mydb/db"

Can someone please help me to solve this issue?
Thanks
Sudipta

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-01-22 21:24:27 Re: Old/New
Previous Message Bob Pawley 2010-01-22 21:16:25 Re: Old/New