Re: LC_COLLATE problem between linux distros

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?

            regards, tom lane