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
>
> 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/