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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq