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 0E97AD1E18F for ; Fri, 20 Feb 2004 17:46:50 +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 66723-04 for ; Fri, 20 Feb 2004 13:46:30 -0400 (AST) Received: from chuao.fundacite.arg.gov.ve (chuao.fundacite.arg.gov.ve [150.187.103.25]) by svr1.postgresql.org (Postfix) with ESMTP id 46440D1E16F for ; Fri, 20 Feb 2004 13:46:12 -0400 (AST) Received: from fundacite.arg.gov.ve (lan-75.fundacite.arg.gov.ve [192.168.0.75]) by chuao.fundacite.arg.gov.ve (Postfix) with ESMTP id 3BAFD4C83F for ; Fri, 20 Feb 2004 13:32:49 +0400 (GMT) Message-ID: <403647C4.9090208@fundacite.arg.gov.ve> Date: Fri, 20 Feb 2004 13:45:40 -0400 From: Marco Gaiani User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Panic involving a LC_COLLATE issue References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/290 X-Sequence-Number: 12464 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