Panic involving a LC_COLLATE issue

Поиск
Список
Период
Сортировка
От Marco Gaiani
Тема Panic involving a LC_COLLATE issue
Дата
Msg-id 403647C4.9090208@fundacite.arg.gov.ve
обсуждение исходный текст
Ответ на Concerned about previous version still in place  ("Guy Smith" <guy.smith@db.com>)
Ответы Re: Panic involving a LC_COLLATE issue
PosgreSQL hogging resources?
Re: Panic involving a LC_COLLATE issue
Список 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
'en_US.iso885915',
        which is not recognized by setlocale().
        It looks like you need to initdb.
Aborted

Any ideas on how to solve this, desesperatly yours

--
Marco Gaiani
Unidad de Promoción y Relaciones
FUNDACITE ARAGUA
mailto: magaiani@fundacite.arg.gov.ve


В списке pgsql-admin по дате отправления:

Предыдущее
От: Olivier Hubaut
Дата:
Сообщение: Re: ANALYZE crashes randomly
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Panic involving a LC_COLLATE issue