Thread

1. initdb failing for chinese locale on windows machine

   Chetan Suttraway <chetan.suttraway@enterprisedb.com> — 2010-04-13T12:25:14Z

   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
   

2. Re: initdb failing for chinese locale on windows machine

   Magnus Hagander <magnus@hagander.net> — 2010-04-13T12:38:32Z

   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/
   
   

3. Re: initdb failing for chinese locale on windows machine

   Chetan Suttraway <chetan.suttraway@enterprisedb.com> — 2010-04-13T12:50:25Z

   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.
   
   
   -- 
   Chetan Sutrave
   http://www.enterprisedb.com
   

4. Re: initdb failing for chinese locale on windows machine

   Dave Page <dpage@pgadmin.org> — 2010-04-13T12:54:20Z

   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