From cjwhite@cisco.com Thu Apr 8 17:53:10 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 85D69D1CCC5 for ; Thu, 8 Apr 2004 14:53:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37494-05 for ; Thu, 8 Apr 2004 14:52:54 -0300 (ADT) Received: from sj-iport-5.cisco.com (sj-iport-5.cisco.com [171.68.10.87]) by svr1.postgresql.org (Postfix) with ESMTP id 26BDBD1D9CB for ; Thu, 8 Apr 2004 14:52:53 -0300 (ADT) Received: from sj-core-4.cisco.com (171.68.223.138) by sj-iport-5.cisco.com with ESMTP; 08 Apr 2004 10:53:50 -0700 Received: from cjwhitew2k02 (sjc-vpn1-300.cisco.com [10.21.97.44]) by sj-core-4.cisco.com (8.12.10/8.12.6) with ESMTP id i38Hqpew013328 for ; Thu, 8 Apr 2004 10:52:51 -0700 (PDT) Reply-To: From: "Chris White (cjwhite)" To: Subject: Error during startup of 7.4.2 database Date: Thu, 8 Apr 2004 10:52:50 -0700 Message-ID: <006801c41d92$4fcd1e90$0300a8c0@amer.cisco.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0069_01C41D57.A36E4690" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200404/160 X-Sequence-Number: 13133 This is a multi-part message in MIME format. ------=_NextPart_000_0069_01C41D57.A36E4690 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0069_01C41D57.A36E4690 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
I have ju= st=20 installed 7.4.2 and initialized a database using the default values. When I= =20 start the database It fails with the following message:
 
FATAL:&nb= sp; invalid=20 value for parameter "lc_messages": "en_US"
 
Looking a= t the=20 postgresql.conf file I see the following lines:
 
# These s= ettings are=20 initialized by initdb -- they may be changed
lc_messages =3D=20 'en_US'           # local= e for=20 system error message strings
lc_monetary =3D=20 'en_US'           # local= e for=20 monetary formatting
lc_numeric =3D=20 'en_US'            #= =20 locale for number formatting
lc_time =3D=20 'en_US'           &n= bsp;          =20 # locale for time formatting
Why am I = getting=20 this error message?
 
Chris=20 White
------=_NextPart_000_0069_01C41D57.A36E4690-- From cjwhite@cisco.com Thu Apr 8 21:04:03 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0F085D1C995 for ; Thu, 8 Apr 2004 18:04:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15780-05 for ; Thu, 8 Apr 2004 18:04:03 -0300 (ADT) Received: from sj-iport-4.cisco.com (sj-iport-4.cisco.com [171.68.10.86]) by svr1.postgresql.org (Postfix) with ESMTP id 6B72AD1B566 for ; Thu, 8 Apr 2004 18:04:00 -0300 (ADT) Received: from cjwhitew2k02 (dhcp-128-107-151-119.cisco.com [128.107.151.119]) by sj-core-4.cisco.com (8.12.10/8.12.6) with ESMTP id i38L3xew017485; Thu, 8 Apr 2004 14:03:59 -0700 (PDT) Reply-To: From: "Chris White (cjwhite)" To: , Subject: Re: Error during startup of 7.4.2 database Date: Thu, 8 Apr 2004 14:03:58 -0700 Message-ID: <000401c41dad$032b8cf0$77976b80@amer.cisco.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C41D72.56CE3B90" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 In-reply-to: <006801c41d92$4fcd1e90$0300a8c0@amer.cisco.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/163 X-Sequence-Number: 13136 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C41D72.56CE3B90 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 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 ------=_NextPart_000_0005_01C41D72.56CE3B90 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
Okay=20 have found info in documentation and have change locale support to=20 C.
-----Original Message-----
From:=20 pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org= ]=20 On Behalf Of Chris White (cjwhite)
Sent: Thursday, April= 08,=20 2004 10:53 AM
To: pgsql-admin@postgresql.org
Subject:= =20 [ADMIN] Error during startup of 7.4.2 database

I have = just=20 installed 7.4.2 and initialized a database using the default values. When= I=20 start the database It fails with the following message:
 
FATAL:&= nbsp;=20 invalid value for parameter "lc_messages": "en_US"
 
Looking= at the=20 postgresql.conf file I see the following lines:
 
# These= settings=20 are initialized by initdb -- they may be changed
lc_messages =3D=20 'en_US'           # loc= ale=20 for system error message strings
lc_monetary =3D=20 'en_US'           # loc= ale=20 for monetary formatting
lc_numeric =3D=20 'en_US'           = #=20 locale for number formatting
lc_time =3D=20 'en_US'           =            =20 # locale for time formatting
Why am = I getting=20 this error message?
 
Chris= =20 White
------=_NextPart_000_0005_01C41D72.56CE3B90-- From tgl@sss.pgh.pa.us Fri Apr 9 04:00:46 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7CDBED1C995 for ; Fri, 9 Apr 2004 01:00:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36330-10 for ; Fri, 9 Apr 2004 01:00:43 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CDC01D1BBA1 for ; Fri, 9 Apr 2004 01:00:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3940crg020657; Fri, 9 Apr 2004 00:00:38 -0400 (EDT) To: cjwhite@cisco.com Cc: pgsql-admin@postgresql.org Subject: Re: Error during startup of 7.4.2 database In-reply-to: <006801c41d92$4fcd1e90$0300a8c0@amer.cisco.com> References: <006801c41d92$4fcd1e90$0300a8c0@amer.cisco.com> Comments: In-reply-to "Chris White (cjwhite)" message dated "Thu, 08 Apr 2004 10:52:50 -0700" Date: Fri, 09 Apr 2004 00:00:38 -0400 Message-ID: <20656.1081483238@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/172 X-Sequence-Number: 13145 "Chris White (cjwhite)" 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