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

Panic involving a LC_COLLATE issue

From: Marco Gaiani <mgaiani(at)fundacite(dot)arg(dot)gov(dot)ve>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Panic involving a LC_COLLATE issue
Date: 2004-02-20 17:45:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 
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.

I have tried to mount it with Mandrake 9.2 and Postgres 7.3.3 but I get 
this error:

DEBUG:  FindExec: searching PATH ...
DEBUG:  ValidateBinary: can't stat "/bin/postgres"
DEBUG:  FindExec: found "/usr/bin/postgres" using PATH
DEBUG:  invoking IpcMemoryCreate(size=983040)
PANIC:  The database cluster was initialized with LC_COLLATE 
        which is not recognized by setlocale().
        It looks like you need to initdb.

Any ideas on how to solve this, desesperatly yours

Marco Gaiani
Unidad de PromociĆ³n y Relaciones
mailto: magaiani(at)fundacite(dot)arg(dot)gov(dot)ve

In response to


pgsql-admin by date

Next:From: Andrew SullivanDate: 2004-02-20 18:23:59
Subject: Re: Panic involving a LC_COLLATE issue
Previous:From: EricDate: 2004-02-20 16:29:35
Subject: User Privileges on large object

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