Re: LC_COLLATE problem between linux distros

On Fri, 2002-10-04 at 01:37, Tom Lane wrote:
> Craig Longman <craigl(at)begeek(dot)com> writes:
> > FATAL 2: The database cluster was initialized with LC_COLLATE 'en_US',
> > which is not recognized by setlocale().
> > It looks like you need to initdb.
>
> > seems pretty strange as i imagine that debian installs en_US as a locale
> > option.
>
> I'd have imagined that too, but it seems not; leastwise the error
> message is pretty definitive about what Postgres is being told by
> setlocale(). Look in /usr/share/locale/ --- is there an en_US
> subdirectory? If not, maybe you missed installing some locale RPMs?

initially, there wasn't in /use/share/locale, only:
en, en_AU, en_GB, en_RN

i created a link for en_US to en, but that didn't seem to help.

perhaps i can copy the en_US directory over from a redhat install i
have, or even duplicate the whole 'en' directory in there? i'll try
that. maybe the debian packagers simply assume that en_US is the
definitive en and doesn't need to be further qualified. this is awfully
strange.

thanks for the response!

--

CraigL->Thx();
Be Developer ID: 5852