Hi there,

I am having a hard time installing PostgreSQL for the first time. I
worked my way through the INSTALL instructions upto the initialization
of the database. ./configure --with-java, gmake, gmake install and
gmake check all run successfully. At the bottom of the mail is what I
got when trying to initdb. Someone in this list suggested a problem
with locales. Unfortunatly I am not a Linux guru (I am running Suse 8),
so I didn't understand much of that. Can someone provide me with
help/hints?

TIA chris

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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Christian Poecher <Poecher (AT) gmx (DOT) net> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly