initdb failing for chinese locale on windows machine

From: Chetan Suttraway <chetan(dot)suttraway(at)enterprisedb(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: initdb failing for chinese locale on windows machine
Date: 2010-04-13 12:25:14
Message-ID: l2qd26e86811004130525x7954e25ehfc403b32442d13b2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I am trying to install postgres 8.4.3.1 on windows machine which has
chinese locale.
The install wizard throws warning message and continues.
However the logs show that initdb failed and so the service was not started.

Have tested this on windows 95 but I think this problem can be reproduced on
latest windows release.

Here are the detailed steps to reproduce the problem:

Steps to reproduce:
----------------------------

1. On windows (95) machine, change the system locale to chinese.
To do this, Click on start->control panel->Regional and language options".
Then under "Regional Options" tab, select "Chinese(Hong Kong S.A.R.) from
the drop down list for "Standards and formats".
Then select "Hong Kong S.A.R." for "location".

2. Log off and login again with the new regional settings.

3. Install postgresql 8.4 using postgresql-8.4.3-1-windows.exe
Do make sure that you select locale as "[Default locale]"
and tick "Install pl/pgsql in template1 database?"

4. A warning/info message box is displayed.

5. check the related log file (generated in temp directory).

I am attaching the log file for reference.

Close to the end of log file, one can see below messages:
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in C:/Program Files/PostgreSQL/8.4/data/
base/1 ... FATAL: invalid value for parameter "lc_monetary": "Chinese_Hong
Kong S.A.R..950"
child process exited with exit code 1
initdb: removing contents of data directory "C:/Program
Files/PostgreSQL/8.4/data"

Regards,
Chetan

--
Chetan Sutrave,
EnterpriseDB <http://www.enterprisedb.com/>http://www.enterprisedb.com

Attachment Content-Type Size
postgresql_chinese.log application/octet-stream 248.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2010-04-13 12:38:32 Re: initdb failing for chinese locale on windows machine
Previous Message Magnus Hagander 2010-04-13 12:09:16 Timezone matching script (win32)