Christian Poecher <Poecher@gmx.net> writes:
> postgresql@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@euro
> MESSAGES: de_DE@euro
> MONETARY: de_DE@euro
> NUMERIC: de_DE@euro
> TIME: de_DE@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@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