I finally got 7.3b1 running on 10.2. setting the local to "C" got it
to run.
Much thanks to all.
Michael
On Tuesday, September 10, 2002, at 01:16 PM, Bruce Momjian wrote:
> 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
>
