Thread: Failed to initialize lc_messages to ''
Hi, I have problem start database. 1) I compile postgresql 7.3.3 with parameters. ./configure --enable-nls --enable-multibyte --enable-locale 2) Then set env variables , export LANG=cs_CZ 3) initdb -D /my_cz_db Initdb returned : The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale cs_CS. This locale setting will prevent the use of indexes for pattern matching operations. If that is a concern, rerun initdb with the collation order set to "C". For more information see the Administrator's Guide. Fixing permissions on existing directory /var/lib/postgres/data2... ok creating directory /var/lib/postgres/data2/base... ok creating directory /var/lib/postgres/data2/global... ok creating directory /var/lib/postgres/data2/pg_xlog... ok creating directory /var/lib/postgres/data2/pg_clog... ok creating template1 database in /var/lib/postgres/data2/base/1... ok creating configuration files... ok initializing pg_shadow... Failed to initialize lc_messages to '' ok enabling unlimited row size for system tables... Failed to initialize lc_messages to '' ok initializing pg_depend... Failed to initialize lc_messages to '' ok creating system views... Failed to initialize lc_messages to '' ok loading pg_description... Failed to initialize lc_messages to '' ok creating conversions... Failed to initialize lc_messages to '' ok setting privileges on built-in objects... Failed to initialize lc_messages to '' ok vacuuming database template1... Failed to initialize lc_messages to '' ok copying template1 to template0... Failed to initialize lc_messages to '' ok 4) /usr/local/pgsql/bin/postmaster -D /var/lib/postgres/my_cz_db Postmaster returned: Failed to initialize lc_messages to '' FATAL: invalid value for option 'LC_MESSAGES': 'cs_CZ' Thanks. -- Rado Petrik <r.p@szm.sk>
Rado Petrik <r.p@szm.sk> writes: > export LANG=cs_CZ > Failed to initialize lc_messages to '' > FATAL: invalid value for option 'LC_MESSAGES': 'cs_CZ' Evidently your platform doesn't have complete support for setting locale to cs_CZ. Try it again with a combination likeexport LANG=cs_CZ export LC_MESSAGES=C regards, tom lane
It seems that one of the other locale variables (LC_ALL?) still contains values that are not accepted. Note that initdb reports about cs_CS, which is not what you set. Rado Petrik writes: > Hi, > I have problem start database. > > 1) I compile postgresql 7.3.3 with parameters. > > ./configure --enable-nls --enable-multibyte --enable-locale > > 2) Then set env variables , > > export LANG=cs_CZ > > 3) initdb -D /my_cz_db > > Initdb returned : > > The files belonging to this database system will be owned by user > "postgres". > This user must also own the server process. > > The database cluster will be initialized with locale cs_CS. > This locale setting will prevent the use of indexes for pattern matching > operations. If that is a concern, rerun initdb with the collation order > set to "C". For more information see the Administrator's Guide. > > Fixing permissions on existing directory /var/lib/postgres/data2... ok > creating directory /var/lib/postgres/data2/base... ok > creating directory /var/lib/postgres/data2/global... ok > creating directory /var/lib/postgres/data2/pg_xlog... ok > creating directory /var/lib/postgres/data2/pg_clog... ok > creating template1 database in /var/lib/postgres/data2/base/1... ok > creating configuration files... ok > initializing pg_shadow... Failed to initialize lc_messages to '' > ok > enabling unlimited row size for system tables... Failed to initialize > lc_messages to '' > ok > initializing pg_depend... Failed to initialize lc_messages to '' > ok > creating system views... Failed to initialize lc_messages to '' > ok > loading pg_description... Failed to initialize lc_messages to '' > ok > creating conversions... Failed to initialize lc_messages to '' > ok > setting privileges on built-in objects... Failed to initialize > lc_messages to '' > ok > vacuuming database template1... Failed to initialize lc_messages to '' > ok > copying template1 to template0... Failed to initialize lc_messages to '' > ok > > > 4) /usr/local/pgsql/bin/postmaster -D /var/lib/postgres/my_cz_db > > Postmaster returned: > > Failed to initialize lc_messages to '' > FATAL: invalid value for option 'LC_MESSAGES': 'cs_CZ' > > Thanks. > > -- Peter Eisentraut peter_e@gmx.net