Thread: 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
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
Okay have found info in documentation and have change locale support to C.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris White (cjwhite)
Sent: Thursday, April 08, 2004 10:53 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Error during startup of 7.4.2 databaseI 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 formattingWhy am I getting this error message?Chris White
"Chris White (cjwhite)" <cjwhite@cisco.com> writes: > 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" 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