Re: [GENERAL] Problems with pgsql 8.0.4 & freebsd 6: partially solved

[Vivek Khera]

On Jan 24, 2006, at 7:47 AM, Vittorio wrote:


Yesterday, I upgraded freebsd from 5.4 to 6 via
the CD (the iso was downloaded from ftp.freebsd.org).


I've done this many times with no problems.

However.

You serve yourself very well by recompiling all your ports or  
reinstalling the packages to be the ones built against 6.0.  This is  
especially necessary for libraries and programs that link against  
those libraries and those programs that dynamically load extensions  
(such as postgres).  Otherwise you're forcing two copies of libc to  
load at the same time in some cases and that causes no end of confusion.




smime.p7s
Description: S/MIME cryptographic signature

Re: [GENERAL] Problems with pgsql 8.0.4 & freebsd 6: partially solved

[Tom Lane]

Vittorio <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org