initdb failing for chinese locale on windows machine - Mailing list pgsql-hackers

From Chetan Suttraway
Subject initdb failing for chinese locale on windows machine
Date
Msg-id l2qd26e86811004130525x7954e25ehfc403b32442d13b2@mail.gmail.com
Whole thread Raw
Responses Re: initdb failing for chinese locale on windows machine  (Magnus Hagander <magnus@hagander.net>)
List 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


Attachment

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Timezone matching script (win32)
Next
From: Magnus Hagander
Date:
Subject: Re: initdb failing for chinese locale on windows machine