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
