From owner-freebsd-questions@FreeBSD.ORG Tue Jan 24 12:47:45 2006 Return-Path: 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 1DED316A41F for ; Tue, 24 Jan 2006 12:47:45 +0000 (GMT) (envelope-from vdemart1@tin.it) Received: from vsmtp2.tin.it (vsmtp2.tin.it [212.216.176.222]) by mx1.FreeBSD.org (Postfix) with ESMTP id B410643D45 for ; Tue, 24 Jan 2006 12:47:44 +0000 (GMT) (envelope-from vdemart1@tin.it) Received: from pswm7.cp.tin.it (192.168.70.27) by vsmtp2.tin.it (7.2.060.1) id 43D2259500270AFF; Tue, 24 Jan 2006 13:47:57 +0100 Message-ID: <2312572.1138106860548.JavaMail.root@pswm7.cp.tin.it> Date: Tue, 24 Jan 2006 13:47:40 +0100 (GMT+01:00) From: Vittorio To: pgsql-general@postgresql.org Mime-Version: 1.0 Content-Type: text/plain;charset="UTF-8" Content-Transfer-Encoding: 7bit X-Originating-IP: 193.108.204.20 Cc: freebsd-questions@freebsd.org Subject: Problems with pgsql 8.0.4 & freebsd 6: partially solved X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Vittorio List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Jan 2006 12:47:45 -0000 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