Re: Panic involving a LC_COLLATE issue

On Fri, Feb 20, 2004 at 01:45:40PM -0400, Marco Gaiani wrote:
> Hi all,
>
> I have experienced a distressing problem lately with my hosting provider
> (they run RedHat), they had to downgrade their version of Postgresql
> from 7.3.4 to 7.3.3 due to 7.3.4 "crashing" constantly. Instead of doing

First, this sounds pretty dodgy to me. I have a feeling that they're
overlooking some other problem. But that won't help you.

> a pg_dump of my databases they copied the data directory somewhere else
> as data_old and went on with the downgrade of Postgres. They have not
> been able to restore my databases but sent me a copy of the data directory.

This is ok -- the binaries are compatible across major versions, so a
7.3.3 tree should work with 7.3.x

> 'en_US.iso885915',
> which is not recognized by setlocale().
> It looks like you need to initdb.
> Aborted

You need the locale support offered by the Red Hat system. Seems you
need ISO 8859-15. My bet is either that Mandrake's locale doesn't
support that, you don't have the right libs, or the binary you've
installed wasn't compiled with the right support. Can you actually
set your LANG to iso885915?

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin