remove

From: "Thomas LeBlanc" <thomasatiem(at)hotmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: remove
Date: 2006-06-08 19:19:17
Message-ID: BAY106-W2AD09108AF0F7B149C736B78B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin

remove

----------------------------------------
> Subject: Re: [ADMIN] Database wont start anyway
> From: miracee(at)miracee(dot)de
> To: fourat(at)gmail(dot)com
> CC: pgsql-admin(at)postgresql(dot)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(at)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(at)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(at)euro
> de_DE.iso885915
> de_DE(dot)iso885915(at)euro
>
> When I run locale, that list will diplayed:
>
> $ locale
>
> LANG=de_DE(at)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(at)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/

Browse pgsql-admin by date

  From Date Subject
Next Message Dirk Lutzeb├Ąck 2006-06-09 13:25:55 How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
Previous Message Jim C. Nasby 2006-06-08 16:33:41 Re: Maximum text and bytea size?