From owner-freebsd-questions@FreeBSD.ORG  Tue Jan 24 15:24:16 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id D6AA716A41F
	for <freebsd-questions@freebsd.org>;
	Tue, 24 Jan 2006 15:24:16 +0000 (GMT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 75B8D43D46
	for <freebsd-questions@freebsd.org>;
	Tue, 24 Jan 2006 15:24:16 +0000 (GMT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0OFOFeR018700;
	Tue, 24 Jan 2006 10:24:15 -0500 (EST)
To: Vittorio <vdemart1@tin.it>
In-reply-to: <2312572.1138106860548.JavaMail.root@pswm7.cp.tin.it> 
References: <2312572.1138106860548.JavaMail.root@pswm7.cp.tin.it>
Comments: In-reply-to Vittorio <vdemart1@tin.it>
	message dated "Tue, 24 Jan 2006 13:47:40 +0100"
Date: Tue, 24 Jan 2006 10:24:15 -0500
Message-ID: <18699.1138116255@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org, freebsd-questions@freebsd.org
Subject: Re: [GENERAL] Problems with pgsql 8.0.4 & freebsd 6: partially
	solved 
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 24 Jan 2006 15:24:17 -0000

Vittorio <vdemart1@tin.it> writes:
> FATAL:  XX000: failed to initialize lc_messages to ""
> LOCATION:  InitializeGUCOptions, guc.c:3699

We've seen that reported before, on more than one platform (I recall
hearing about it on OS X, for instance).  But no one's ever been able
to explain what causes it.  It's interesting to hear that a full
database reinstall made it go away for you, but that was certainly
overkill.  Do you have the time to experiment with the locale settings
and see if you can identify the difference between the cases where it
happens and those where it doesn't?

> After many attempts I discovered that the problem was connected to the
> "setenv LC_ALL it_IT.ISO_8859-1" I had introduced in /usr/local/pgsql/.cshrc

Do you have any other LC_xxx variables set?  How about LANG?  Is that
string still a valid locale name on your updated platform?

			regards, tom lane