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 B96FC9FA1A4 for ; Thu, 8 Jun 2006 13:13:14 -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 73160-09 for ; Thu, 8 Jun 2006 13:13:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.andy.de (mail.nxdomain.de [212.8.199.66]) by postgresql.org (Postfix) with ESMTP id 4D1FF9FA3CD for ; Thu, 8 Jun 2006 13:13:04 -0300 (ADT) Received: from localhost (mail.nxdomain.de [212.8.199.66]) by mail.andy.de (Postfix) with ESMTP id 9FF2A22A585; Thu, 8 Jun 2006 18:13:03 +0200 (CEST) Received: from mail.andy.de ([212.8.199.66]) by localhost (mail.andy.de [212.8.199.66]) (amavisd-new, port 10024) with ESMTP id 85670-05; Thu, 8 Jun 2006 18:12:56 +0200 (CEST) Received: from kermit (port-212-202-8-153.dynamic.qsc.de [212.202.8.153]) by mail.andy.de (Postfix) with ESMTP id 1A28A22A59A; Thu, 8 Jun 2006 18:12:56 +0200 (CEST) Subject: Re: Database wont start anyway From: Susanne Ebrecht To: Fourat Zouari Cc: pgsql-admin@postgresql.org In-Reply-To: <621eda8a0606080244o3af21c8cncb4c4afd842732f9@mail.gmail.com> References: <621eda8a0606080244o3af21c8cncb4c4afd842732f9@mail.gmail.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-ogxUVZtVuVB5J78S/ED7" Date: Thu, 08 Jun 2006 18:12:55 +0200 Message-Id: <1149783175.4893.18.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 X-Virus-Scanned: amavisd-new at nxdomain.de X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/60 X-Sequence-Number: 22022 --=-ogxUVZtVuVB5J78S/ED7 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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! It looks like a linux system. Or which OS do you use? Do you tried to start PG as root (because of the #)? Are you sure root is allowed to start it? Is root superuser? Try to start it as user postgres. all installed locales will listen by: $ locale -a I have no french locale installed on my debian system, but you will get a list like this: C de_DE@euro de_DE.iso885915 de_DE.iso885915@euro When I run locale, that list will diplayed: $ locale LANG=3Dde_DE@euro LANGUAGE=3Dde_DE:de:en_GB:en It is the same, as your list. Only fr_FR (France) instead de_DE (Germany). So I am sure, the problem is, that you tried to start postgresql as root and not as superuser. The standard superuser is postgres. Try this: tux2:~# su postgres postgres@tux2:~$ /etc/init.d/postgresql-8.1 start Susanne --=-ogxUVZtVuVB5J78S/ED7 Content-Type: application/pgp-signature; name=signature.asc Content-Description: Dies ist ein digital signierter Nachrichtenteil -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) iD8DBQBEiEyHXwA2sATD8vcRAoK8AJ47j6St2imSxAGbYGi+pN6KBJ6zbwCfXtVM jqu6rJwB4qzJr7qw1mxSiPo= =XQRq -----END PGP SIGNATURE----- --=-ogxUVZtVuVB5J78S/ED7--