Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
From: letters AT hotpop DOT com (Jari Aalto+list.cygwin)
To: cygwin AT cygwin DOT com
Subject: Re: postgresql postmaster and LC_MESSAGES EN_US problem
Keywords: tishler,initdb,cygwin,jason,net,lang
X-Sender-Info: Emacs resources http://tiny-tools.sourceforge.net/
  http://poboxes.com/jari.aalto ICQ 'jari-aalto' 82313129
  PGP 2.6.x keyid 47141D35 http://www.pgpi.net/
References: <56FDB31BE5F1D611ACB20002A544EB2467AC04 AT MCDC-ATL-5>
	<20021212124037 DOT GB900 AT tishler DOT net> <pts5mw5d DOT fsf AT blue DOT sea DOT net>
	<20021217122921 DOT GA1968 AT tishler DOT net>
Date: Thu, 19 Dec 2002 00:08:26 +0200
In-Reply-To: <20021217122921.GA1968@tishler.net> (Jason Tishler's message of
 "Tue, 17 Dec 2002 07:29:21 -0500")
Message-ID: <ptrzrndx.fsf@blue.sea.net>
User-Agent: Gnus/5.090008 (Oort Gnus v0.08) Emacs/20.7 (i386-*-nt5.0.2195)
 (i386-*-nt5.0.2195)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

* Tue 2002-12-17 Jason Tishler <jason AT tishler DOT net> list.cygwin
* Message-Id: <20021217122921 DOT GA1968 AT tishler DOT net>
>
> On Fri, Dec 13, 2002 at 11:44:30PM +0200, Jari Aalto wrote:
>> * Thu 2002-12-12 Jason Tishler <jason AT tishler DOT net> list.cygwin
>> > It appears that having LANG=en_us set before you ran initdb caused
>> > this problem.  My recommendation it to either unset LANG or use
>> > LANG=C before you rerun initdb.
>> >
>> May I suggest that the documentation says:
>> 
>>     $ env LC_ALL=C initdb -D /usr/share/postgresql/data
>
> IMO, the above is unnecessary unless the default Cygwin environment sets
> any of locale related environment variables to something other that "C".

I have set LC_ALL=en_US in my Cygwin setup and it took quite a while
yo giess why did the 7.3 upgrade failed. It gives mysterious error
messages when the initdb was run with that locale in effect.

I still think it would be good idea suggest in Cygwin/postgres 
documentaion to say that the loate is crucial when database is created. 
Hence he safest way:

     $ env LC_ALL=C initdb -D /usr/share/postgresql/data

I remember that there was something special with locate C?

Jari


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/