Skip site navigation (1) Skip section navigation (2)

Re: Problem with initdb. Locale?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christian Poecher <Poecher(at)gmx(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem with initdb. Locale?
Date: 2004-01-23 15:27:21
Message-ID: 27040.1074871641@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Christian Poecher <Poecher(at)gmx(dot)net> writes:
> postgresql(at)ds217-115-144-40:~> /usr/local/pgsql/bin/initdb -D 
> /usr/local/pgsql/data
> The files belonging to this database system will be owned by user 
> "postgresql".
> This user must also own the server process.

> The database cluster will be initialized with locales:
>    COLLATE:  POSIX
>    CTYPE:    de_DE(at)euro
>    MESSAGES: de_DE(at)euro
>    MONETARY: de_DE(at)euro
>    NUMERIC:  de_DE(at)euro
>    TIME:     de_DE(at)euro

> fixing permissions on existing directory /usr/local/pgsql/data... ok
> creating directory /usr/local/pgsql/data/base... ok
> creating directory /usr/local/pgsql/data/global... ok
> creating directory /usr/local/pgsql/data/pg_xlog... ok
> creating directory /usr/local/pgsql/data/pg_clog... ok
> selecting default max_connections... 10
> selecting default shared_buffers... 50
> creating configuration files... ok
> creating template1 database in /usr/local/pgsql/data/base/1... FATAL:  
> XX000: failed to initialize lc_messages to ""
> LOCATION:  InitializeGUCOptions, guc.c:1866

> initdb: failed

Try it with

	export LC_ALL="C"
	initdb ...

The complaint is a bit opaque :-( but it's unhappy because of the fact
that LC_MESSAGES is implicitly de_DE(at)euro, a setting that apparently
does not actually work on your platform.

If you don't want English error messages, you could also try
experimenting with other locale values --- "de_DE" might work for
instance.  I recommend leaving LC_COLLATE as POSIX (or equivalently C),
though.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2004-01-23 16:15:11
Subject: Re: 7.4.1 template1
Previous:From: Bruno Wolff IIIDate: 2004-01-23 15:12:15
Subject: Re: pg_atoi error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group