Tom Lane wrote: > Michael Fortin <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
