Thread: Failed to initialize lc_messages to ''

Failed to initialize lc_messages to ''

From
Rado Petrik
Date:
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>



Re: Failed to initialize lc_messages to ''

From
Tom Lane
Date:
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


Re: Failed to initialize lc_messages to ''

From
Peter Eisentraut
Date:
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