Thread: 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/

On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
<chetan.suttraway@enterprisedb.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 HaganderMe: http://www.hagander.net/Work: http://www.redpill-linpro.com/

<br /><br /><div class="gmail_quote">On Tue, Apr 13, 2010 at 6:08 PM, Magnus Hagander <span dir="ltr"><<a
href="mailto:magnus@hagander.net">magnus@hagander.net</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">On Tue,
Apr13, 2010 at 14:25, Chetan Suttraway<br /> <<a
href="mailto:chetan.suttraway@enterprisedb.com">chetan.suttraway@enterprisedb.com</a>>wrote:<br /> > Hi,<br />
><br/> > I am trying to install postgres 8.4.3.1 on windows  machine which has<br /> > chinese locale.<br />
>The install wizard throws warning message and continues.<br /> > However the logs show that initdb failed and so
theservice was not started.<br /> ><br /> > Have tested this on windows 95 but I think this problem can be
reproducedon<br /> > latest windows release.<br /><br /></div>PostgreSQL is not supported on Windows 95 as a server,
andhas never<br /> been. Only under cygwin, in which case you should be using a<br /> completely different
installer.<br/><font color="#888888"><br /> --<br />  Magnus Hagander<br />  Me: <a href="http://www.hagander.net/"
target="_blank">http://www.hagander.net/</a><br/>  Work: <a href="http://www.redpill-linpro.com/"
target="_blank">http://www.redpill-linpro.com/</a><br/></font></blockquote></div><br />This is reproducible on windows
xp.<br/><br clear="all" /><br />-- <br />Chetan Sutrave<br /><a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br/><br /> 

On Tue, Apr 13, 2010 at 1:50 PM, Chetan Suttraway
<chetan.suttraway@enterprisedb.com> wrote:
>
>
> On Tue, Apr 13, 2010 at 6:08 PM, Magnus Hagander <magnus@hagander.net>
> wrote:
>>
>> On Tue, Apr 13, 2010 at 14:25, Chetan Suttraway
>> <chetan.suttraway@enterprisedb.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