Re: make unsuccessful on mac os x 10.2

Tom Lane wrote:
> Michael Fortin <pommele@mindspring.com> writes:
> > This are the only log entries produced at startup:
> > Failed to initialize lc_time to ''
> > FATAL:  invalid value for option 'LC_TIME': 'en_US'
>
> The first of these is a mistake (Peter thought he'd fixed it a month
> ago, but his fix was incomplete; I believe I've fixed the fix, and am
> about to reboot into OSX to check).  The second is OS X's bug: it ought
> to take en_US as a legal setting for LC_TIME, but seems not to.  It is
> depressing that Apple evidently didn't fix that in 10.2.  See prior
> discussion
> http://archives.postgresql.org/pgsql-admin/2002-08/msg00062.php
>
> It seems we have not done anything about trying to validate the user's
> LANG/LC_xxx environment settings, and so initdb is quite capable of
> accepting settings that will prevent the postmaster from starting.
> The short-term fix is to fix your LANG before initdb, or tweak the
> postgresql.conf file after.

And he is getting during initdb:

>> The database cluster will be initialized with locale en_US.
>> This locale setting will prevent the use of indexes for pattern
>> matching
>> operations.  If that is a concern, rerun initdb with the collation
>> order
>> set to "C".  For more information see the Administrator's Guide.

which means that unless he really wants a special locale he should use C
locale anyway.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073