X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 08112D1E166 for ; Fri, 20 Feb 2004 18:25:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85246-03 for ; Fri, 20 Feb 2004 14:25:24 -0400 (AST) Received: from fep03-mail.bloor.is.net.cable.rogers.com (fep03-mail.bloor.is.net.cable.rogers.com [66.185.86.73]) by svr1.postgresql.org (Postfix) with ESMTP id 08D22D1E1E5 for ; Fri, 20 Feb 2004 14:24:00 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep03-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040220182359.ZYOH189272.fep03-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Fri, 20 Feb 2004 13:23:59 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 0751A3F3A; Fri, 20 Feb 2004 13:23:59 -0500 (EST) Date: Fri, 20 Feb 2004 13:23:59 -0500 From: Andrew Sullivan To: "pgsql-admin@postgresql.org" Subject: Re: Panic involving a LC_COLLATE issue Message-ID: <20040220182358.GA16116@phlogiston.dyndns.org> Mail-Followup-To: "pgsql-admin@postgresql.org" References: <403647C4.9090208@fundacite.arg.gov.ve> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <403647C4.9090208@fundacite.arg.gov.ve> User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep03-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Fri, 20 Feb 2004 13:23:59 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/291 X-Sequence-Number: 12465 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@crankycanuck.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