Re: initdb failing for chinese locale on windows machine

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

On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
<chetan(dot)suttraway(at)enterprisedb(dot)com> wrote:
> 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.

PostgreSQL is not supported on Windows 95 as a server, and has never
been. Only under cygwin, in which case you should be using a
completely different installer.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

On Tue, Apr 13, 2010 at 6:08 PM, Magnus Hagander <magnus(at)hagander(dot)net>wrote:

> On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
> <chetan(dot)suttraway(at)enterprisedb(dot)com> wrote:
> > 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.
>
> PostgreSQL is not supported on Windows 95 as a server, and has never
> been. Only under cygwin, in which case you should be using a
> completely different installer.
>
> --
> Magnus Hagander
> Me: http://www.hagander.net/
> Work: http://www.redpill-linpro.com/
>

This is reproducible on windows xp.

--
Chetan Sutrave
http://www.enterprisedb.com

On Tue, Apr 13, 2010 at 1:50 PM, Chetan Suttraway
<chetan(dot)suttraway(at)enterprisedb(dot)com> wrote:
>
>
> On Tue, Apr 13, 2010 at 6:08 PM, Magnus Hagander <magnus(at)hagander(dot)net>
> wrote:
>>
>> On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
>> <chetan(dot)suttraway(at)enterprisedb(dot)com> wrote:
>> > 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.
>>
>> PostgreSQL is not supported on Windows 95 as a server, and has never
>> been. Only under cygwin, in which case you should be using a
>> completely different installer.
>>
>> --
>>  Magnus Hagander
>>  Me: http://www.hagander.net/
>>  Work: http://www.redpill-linpro.com/
>
> This is reproducible on windows xp.

PostgreSQL doesn't support BIG5/cp950 as a server-side encoding.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com