Re: Problems with pgsql 8.0.4 & freebsd 6: partially solved

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vittorio <vdemart1(at)tin(dot)it>
Cc: pgsql-general(at)postgresql(dot)org, freebsd-questions(at)freebsd(dot)org
Subject: Re: Problems with pgsql 8.0.4 & freebsd 6: partially solved
Date: 2006-01-24 15:24:15
Message-ID: 18699.1138116255@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vittorio <vdemart1(at)tin(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jimmy Rowe 2006-01-24 15:27:53
Previous Message Tony Caduto 2006-01-24 15:23:38 Re: Does this look ethical to you?