From owner-freebsd-questions Sat Mar 9 14: 6:59 2002 Delivered-To: freebsd-questions@freebsd.org Received: from web1.nexusinternetsolutions.net (web1.nexusinternetsolutions.net [206.47.131.12]) by hub.freebsd.org (Postfix) with SMTP id 97FEC37B417 for ; Sat, 9 Mar 2002 14:06:48 -0800 (PST) Received: (qmail 5090 invoked from network); 9 Mar 2002 22:13:49 -0000 Received: from unknown (HELO cr159591a) (24.102.18.54) by web1.nexusinternetsolutions.net with SMTP; 9 Mar 2002 22:13:49 -0000 From: "Dave" To: "Jeff Fisher" , "Mike Dewhirst" Cc: Subject: RE: postgresql start Date: Sat, 9 Mar 2002 17:09:13 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-reply-to: <20020301093830.A34917@frogger.jeffnet> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG >The scripts in /usr/local/etc/rc.d are designed to be run as root. You'll >either need to run this script at root (which will be done automatically at a >reboot), or start postgres manually as you do below. Try this on for size... recently during a reboot (first in about 3 months for this particular server) our entire rc.d directory failed to start... after some hacking of the rc file to output some helpful debuggin, it was apparent that the 010.pgsql.sh script in /usr/local/etc/rc.d was timing out and causing any directives thereafter not to be processed. Running the script manually as root starts the postmaster but doesn't return you to the command prompt. ^C and checking the errlog shows Waiting for postmaster starting up..DEBUG: Data Base System is starting up at Sat Mar 9 17:05:45 2002 DEBUG: Data Base System was shut down at Sat Mar 9 17:05:39 2002 DEBUG: Data Base System is in production state at Sat Mar 9 17:05:45 2002 Fast Shutdown request at Sat Mar 9 17:05:48 2002 DEBUG: Data Base System shutting down at Sat Mar 9 17:05:48 2002 DEBUG: Data Base System shut down at Sat Mar 9 17:05:48 2002 Can force it to return to command prompt by adding a "&" and doublt cr web1# /usr/local/etc/rc.d/010.pgsql.sh start & [1] 4635 web1# [1] + Suspended (tty output) /usr/local/etc/rc.d/010.pgsql.sh start web1# and postgres stays up and frees the terminal. Output in errlog for this is... Waiting for postmaster starting up..DEBUG: Data Base System is starting up at Sat Mar 9 17:07:21 2002 DEBUG: Data Base System was shut down at Sat Mar 9 17:05:48 2002 DEBUG: Data Base System is in production state at Sat Mar 9 17:07:21 2002 No idea what could be causing the script not to function as it is the EXACT same script as on the other servers we are operating (did a diff just to be sure) In the interim we removed the script from the startup dir... any ideas as to why this is occuring? Installed from port, left the port startup script as is. Dave To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message