Re: LC_COLLATE problem between linux distros

On Fri, 2002-10-04 at 01:37, Tom Lane wrote:
> Craig Longman <craigl@begeek.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