remove ---------------------------------------- > Subject: Re: [ADMIN] Database wont start anyway > From: miracee@xxxxxxxxxx > To: fourat@xxxxxxxxx > CC: pgsql-admin@xxxxxxxxxxxxxx > Date: Thu, 8 Jun 2006 18:12:55 +0200 > > Am Donnerstag, den 08.06.2006, 11:44 +0200 schrieb Fourat Zouari: > > Hello all, > > My database wont start, here's the log : > > > > 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: > > LANGUAGE = "fr_TN:fr_FR:fr:en_GB:en", > > LC_ALL = (unset), > > LANG = "fr_FR@euro" > > are supported and installed on your system. > > perl: warning: Falling back to the standard locale ("C"). > > 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=de_DE@euro > LANGUAGE=de_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 _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/