Skip site navigation (1) Skip section navigation (2)

Re: Panic involving a LC_COLLATE issue

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Panic involving a LC_COLLATE issue
Date: 2004-02-20 18:23:59
Message-ID: 20040220182358.GA16116@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2004-02-20 18:26:41
Subject: Re: "DELETE FROM" protection
Previous:From: Marco GaianiDate: 2004-02-20 17:45:40
Subject: Panic involving a LC_COLLATE issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group