X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 62C909FACFE for ; Thu, 8 Jun 2006 16:19:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19099-01 for ; Thu, 8 Jun 2006 16:19:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bay0-omc1-s10.bay0.hotmail.com (bay0-omc1-s10.bay0.hotmail.com [65.54.246.82]) by postgresql.org (Postfix) with ESMTP id 8563E9FA1A4 for ; Thu, 8 Jun 2006 16:19:18 -0300 (ADT) Received: from BAY106-W2 ([65.54.161.102]) by bay0-omc1-s10.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 8 Jun 2006 12:19:17 -0700 X-Originating-IP: [65.125.90.188] X-Originating-Email: [thomasatiem@hotmail.com] Message-ID: MIME-Version: 1.0 From: "Thomas LeBlanc" To: Subject: remove Date: Thu, 8 Jun 2006 14:19:17 -0500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-OriginalArrivalTime: 08 Jun 2006 19:19:17.0456 (UTC) FILETIME=[6FA73D00:01C68B30] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/62 X-Sequence-Number: 22024 remove ---------------------------------------- > Subject: Re: [ADMIN] Database wont start anyway > From: miracee@miracee.de > To: fourat@gmail.com > CC: pgsql-admin@postgresql.org > Date: Thu, 8 Jun 2006 18:12:55 +0200 >=20 > Am Donnerstag, den 08.06.2006, 11:44 +0200 schrieb Fourat Zouari: > > Hello all, > > My database wont start, here's the log : > >=20 > > tux2:~# /etc/init.d/postgresql-8.1 start > > Starting PostgreSQL 8.1 database server: main* perl: warning: Setting > > locale failed. > > perl: warning: Please check that your locale settings:=20 > > LANGUAGE =3D "fr_TN:fr_FR:fr:en_GB:en", > > LC_ALL =3D (unset), > > LANG =3D "fr_FR@euro" > > are supported and installed on your system. > > perl: warning: Falling back to the standard locale ("C").=20 > > Error: The server must be started under the locale fr_FR@euro which > > does not exist any more. > > failed! >=20 > It looks like a linux system. Or which OS do you use? >=20 > Do you tried to start PG as root (because of the #)? Are you sure root > is allowed to start it? Is root superuser? >=20 > Try to start it as user postgres. >=20 > all installed locales will listen by: > $ locale -a >=20 > I have no french locale installed on my debian system, but you will get > a list like this: >=20 > C > de_DE@euro > de_DE.iso885915 > de_DE.iso885915@euro >=20 > When I run locale, that list will diplayed: >=20 > $ locale >=20 > LANG=3Dde_DE@euro > LANGUAGE=3Dde_DE:de:en_GB:en >=20 > It is the same, as your list. Only fr_FR (France) instead de_DE > (Germany). >=20 > So I am sure, the problem is, that you tried to start postgresql as root > and not as superuser. The standard superuser is postgres. >=20 > Try this: > tux2:~# su postgres > postgres@tux2:~$ /etc/init.d/postgresql-8.1 start >=20 > Susanne _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/=