From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Panic involving a LC_COLLATE issue
Date: Fri, 20 Feb 2004 13:23:59 -0500
Message-ID: <20040220182358.GA16116@phlogiston.dyndns.org> (raw)
In-Reply-To: <403647C4.9090208@fundacite.arg.gov.ve>
References: <OF39CC7F63.2A5441D5-ON80256E3F.003912D3@db.com>
<403647C4.9090208@fundacite.arg.gov.ve>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Panic involving a LC_COLLATE issue
In-Reply-To: <20040220182358.GA16116@phlogiston.dyndns.org>
References: <OF39CC7F63.2A5441D5-ON80256E3F.003912D3@db.com> <403647C4.9090208@fundacite.arg.gov.ve> <20040220182358.GA16116@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox