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

I have been using a postgresql 8.0.4 server under freebsd 5.4 like a
charm for a long time .
Yesterday, I upgraded freebsd from 5.4 to 6 via
the CD (the iso was downloaded from ftp.freebsd.org).

Restating
postgresql it happened:

# /usr/local/etc/rc.d/010.pgsql.sh start
--:
not found
FATAL:  XX000: failed to initialize lc_messages to ""
LOCATION:  InitializeGUCOptions, guc.c:3699
#

And the server was down

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
which corrupted something in the system and, even removing the
line, 010.pgsql.sh went on failing to start the server

Having
pg_dumped the data before the upgrading to 6, I have solved the problem
by
1) eliminating the /usr/local/pgsql/data directory (BY THE WAY,
remember to backup the pgsql *.conf files somewhere!!);
2) deinstalling
the postgresql 8.0.4 server by means of "make deinstall";
3) removing
the pgsql user;
4) reinstalling the postgresql 8.0.4 server;
5) copying
the *.conf files under the data directory
6) pg_restoring the data

Now, of course I have left unmodified the .cshrc file (take notice that
any attempt of modyfying the locale corrupts the postgresql server and
you should start with a new reinstallation! I failed both adding a line
"setenv LC_ALL it_IT.ISO_8859-1" and "setenv LC_ALL it_IT.ISO8859-1")

Now it all works even though an inoffensive warning comes up

#
/usr/local/etc/rc.d/010.pgsql.sh start
--: not found

Is there anything
else I could do?

Ciao
Vittorio

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

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.