Error during startup of 7.4.2 database

[Chris White (cjwhite)]

I have just installed 7.4.2 and initialized a database using the default
values. When I start the database It fails with the following message:

FATAL: invalid value for parameter "lc_messages": "en_US"

Looking at the postgresql.conf file I see the following lines:

# These settings are initialized by initdb -- they may be changed
lc_messages = 'en_US' # locale for system error message
strings
lc_monetary = 'en_US' # locale for monetary formatting
lc_numeric = 'en_US' # locale for number formatting
lc_time = 'en_US' # locale for time formatting

Why am I getting this error message?

Chris White

[Chris White (cjwhite)]

Okay have found info in documentation and have change locale support to
C.

-----Original Message-----
From: pgsql-admin-***@postgresql.org
[mailto:pgsql-admin-***@postgresql.org] On Behalf Of Chris White
(cjwhite)
Sent: Thursday, April 08, 2004 10:53 AM
To: pgsql-***@postgresql.org
Subject: [ADMIN] Error during startup of 7.4.2 database


I have just installed 7.4.2 and initialized a database using the default
values. When I start the database It fails with the following message:

FATAL: invalid value for parameter "lc_messages": "en_US"

Looking at the postgresql.conf file I see the following lines:

# These settings are initialized by initdb -- they may be changed
lc_messages = 'en_US' # locale for system error message
strings
lc_monetary = 'en_US' # locale for monetary formatting
lc_numeric = 'en_US' # locale for number formatting
lc_time = 'en_US' # locale for time formatting

Why am I getting this error message?

Chris White

[Tom Lane]

Post by Chris White (cjwhite)
I have just installed 7.4.2 and initialized a database using the default
FATAL: invalid value for parameter "lc_messages": "en_US"

What platform is this exactly? And exactly how did you build/install
Postgres?

We've seen reports of this ilk before. So far I've written them off
as indicating serious brain damage in the platform's locale support,
but I'm starting to wonder whether there's something else going on.
AFAIR the previous reports involved locales much less commonly used
than en_US.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html